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