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

 

Scheduling a Job within a Daily Job with a single day dependence

Started by adam_mc, 09 Oct 2014 02:19:25 PM

Previous topic - Next topic

adam_mc

We have a Daily Job setup in Cognos Connection that executes many reports.
It is kicked off by a daily trigger that is activated based on Data Warehouse update completion and Cognos Cube creation completion.

I now want to add a second job within this job that needs to run at the end of this job, but ONLY on Monday's.
It is a requirement from the business to run this after the daily job completes so that we can control the number of reports running during our critical morning reporting timeslot.

Can this be scheduled using Cognos Connection?

The following .bat file executes on our Cognos Server to execute the trigger for the Daily Job.
If it can't be done in Cognos Connection, can the .bat file be edited or a second one added to be dependent on this?

@ECHO OFF
cls
:start
if exist "\\Server\Pathname\finish_cognos.txt" (
if exist "\\Server\Pathname\finish_cognos2.txt" (
echo File is there!

cd "D:\Program Files\ibm\cognos10.2.1\c10_64\webapps\utilities\trigger"
d:

trigger.bat "http://server_name:port/p2pd/servlet/dispatch" "USER" "PASSWORD" "XXXX" "AllDaysScheduledReports"
) else (
echo File not found!
ping 1.1.1.1 -n 1 -w 60000 > NUL
goto start
)
) else (
echo File not found!
ping 1.1.1.1 -n 1 -w 60000 > NUL
goto start
)

:end

Any thoughts will be greatly appreciated.
Thanks in advance,
Adam.