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

 

Daily Scheduled Job Running Multiple Reports - Stays in Pending Status

Started by adam_mc, 05 Nov 2012 09:06:04 AM

Previous topic - Next topic

adam_mc

I am facing an issue with a Cognos Job that uses a trigger.
This job should run everyday and is based on a trigger being kicked off when our nightly ETL load is completed.

Most days this works without any issues, although at certain times the job is kicked off correctly (so I presume that trigger is working), but the job in Cognos Administration is at a Pending Status and it contains NO reports to be executed when I view the Run History Status.

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

Below is my trigger syntax (my job is set up in Cognos based on the trigger "AllDaysScheduledReports")
I have a number of other triggers built in the same manner (including Report runs and Cube Builds) that all run as expected.

@ECHO OFF
cls
:start
if exist "\\xfiles\Data\Data Warehouse IQ\start_cognos.txt" (
echo File is there!
cd "D:\Program Files (x86)\ibm\cognos\c10_64\webapps\utilities\trigger"
d:
trigger.bat "http://cognos1.xxxx.com/ibmcognos/cgi-bin/cognos.cgi" "COGNOS ADMIN USER GOES HERE" "PASSWORD GOES HERE" "NAMESPACE GOES HERE" "AllDaysScheduledReports"
) else (
echo File not found!
ping 1.1.1.1 -n 1 -w 60000 > NUL
goto start
)

:end