on 10-07-2008 11:10 AM
Hi,
we have a webi reports based on oracle table.By using ETL Job data is loaded in to oracle tables daily (multiple timings) .
my requirement is i need to schedule this report after ETL JOB ran successfull.
If ETL Job runs daily once or in a specific time i can schedule this report using Event (using Recurrence).
But ETL job runs multiple times in a day.
Whenever ETL job finished my report report should schedule .
Regards,
Sasi
You could use File based events. i.e. create a file when your data is loaded, have BO monitor a specific directory for a specific file. Once that file is available, the report be scheduled. Note that BO will not delete this file.
You will need to come up with a system to delete this file. You could use Program Job based on a successful report schedule to delete the file though.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.