Event Studio: how to stop the report schedule if the database load fails...

[Maple]

is there any way through which report schedule stops automatically if the database load do not finish successfully.

[goose]

Can you elaborate a bit...?

[Maple]

We have scheduled some reports to send via e-mail.  Our database load ran daily in the morning ...some time the database load failed but the schedule ran in the morning and sent our reports with no data ...in this situation we have to send our report twice...i was thinking that is there any other way through which our report schedule stops automatically if the database load did not finish successfully...

[goose]

You can create a table in your db, populate a column with a value for the day from the script that loads the data. In event studio you can check for the existance of the record for the day and then only run the reports if the data was loaded successfully.

[Maple]

perfect...sounds good...I'll try and let you know

Thanks

[newmans_99]

Another (non-EventStudio) option would be to schedule the object (report, query, etc...) based on a trigger rather than a calendar. Then have your Database Update process (ETL tool, etc...) call the trigger to let Cognos know to execute any objects that are associated with that trigger. In the Cognos samples is some sample code on how to "trigger" a trigger from the command line.

[mycognos]

Hi,

Can anyone tell me how to create a trigger based on database refresh? My cognos server and database server are in linux platform. Any help would be appreciated..thanks in advance...