Scheduling Cognos Reports via Control-M Autosys

[john123]

If you want to schedule Cognos Reports via Control-M or Autosys, what part of cognos you call and what parameters you pass?

[megafood]

Hi John,

You can call the trigger.bat under the webapps directory to execute reports or jobs that have a trigger name associated with them, but I found this was useless because the return code will only tell you if the even fired or not. That is to say, the ctrl m job would complete with a success status if the trigger had fired but the job failed. Out of the box, Cognos does not integrate well with 3rd party schedulers.

In any case, we ended up putting in a solution that uses the C8 SDK to execute jobs from the portal and polls the CS for a success/fail condition and echos out error messages if they are found. Cognos developed this for us. We parameterized a lot of stuff, but of importance was the job name, portal location and poll time.

This was v. modular with 8.4 since you could schedule and poll anything in the portal - report sets, cleanup jobs, backups, etc. I can't distribute the code due to internal policy but you could find similar code in the Cognos KB.

Cheers