Hello All
I’m looking for some suggestion to enhance our production stability. I’ve a batch of 160 reports that runs every day based on file based event scheduling.
Now my problem is the scenario where some wrong data gets loaded as part of ETL process and the reports run successfully for the day. We’re required to rerun all the 160 reports again in such cases and right now we’ve to either reschedule all the reports one by one and trigger the event or we manually rerun the reports and send to users.
Any pointers on a better solution will be appreciated. Thank you in advance.
I’m assuming your reports are scheduled to run daily with the file event. I would suggest rescheduling them with a more frequent recurrence period, say two hours. In this case, you can drop the trigger file again during the same day and the reports will run.
Another alternative, would be to create duplicate schedules but triggering off of a Custom Event (Events > Custom Events). These events are ones you manually trigger from within the CMC, you can schedule against them just like scheduling against a file event. The downside to this is you’ll have to have two separate schedules for each report, one file based and one custom event based. The upside is you don’t have to reduce your recurrence frequency of your production jobs, if that is an issue for you. HTH.
(BOB member since 2002-08-29)