If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to check if all "Run Report" tasks of Event Job has finished

Started by colt, 29 Mar 2012 08:16:38 AM

Previous topic - Next topic

colt

Hi,
I have created a scheduled Job in Event Studio, that runs several reports and exports them to filesystem in Excel format. In Windows task scheduler, I have created a task, that opens the exported Excel files, copies them together into one Excel file and reformats them(by vba). (Excel Export especially of Chart-Reports is not solved really good - therefore the changes by vbs).

Now the problem - whenever the execution of the scheduled reports is delayed due to heavy load, the task scheduler task starts and reports are not finished yet which means, that the job uses old versions of the reports.

Is there any possibility to define a task in Event studio as "Last task of the Job"  or is there any way to tell event studio not to run the tasks within the job parallel, but one after the other ?
I want to use this to run a dummy report which just creates a file dummy.pdf that flags, that all the reports of the Job are finished and the vbs-Job can be started.
Just reordering the tasks within Event-Job is not enough, cause multiple tasks run the same time and therefore the dummy might finish before the other reports.

MFGF

You would need to modify the job (not the event agent) to specify that the reports are run sequentially. When you modify the job, change the behaviour from "All at once" to "In Sequence" and check the "Continue on error" checkbox.

Regards,

MF.
Meep!