Disable the Scheduling of Report when our ETL jobs fail

[soma.bss]

Hi Gurus,

We have a Requirement from our client to disable the scheduling of the reports whenever the ETL jobs fail.

Unfortunately since there is no such dependency between the ETL Jobs and Scheduling of reports in our environment. Even if the ETL load fails, the report schedule delivers the yesterdays data to users and it is annoying to the users.

We have SDK environment available, please suggest some ideas on this.

Thanks,
Soma

[avitabj]

Hi!  In my environment, reports are run based on a trigger being sent on success of ETL jobs.  You set the trigger name in the "Run Options" of the report.  I have multiple reports that run off the same trigger.  I think there's even a pre-made java program to trigger an event that is found in the /sdk/java/EventTrigger folder. 

hth...jean

[Ty Clabbers]

Try event studio.

[Rocks]

We also use triggers in our environment, that are called via the completion of an ETL job.  We use them both for report triggers to call reports or jobs, as well as cube builds.