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

Automating Cognos 8 Job runs after Cognos 7 Cube Updates

Started by buyile, 01 Feb 2010 07:13:45 AM

Previous topic - Next topic

buyile

Good day Community

I am faced with a task of trying to automate how we run our jobs.currently we are running them manually once the cubes have been updated.Scheduling them based on the day or time is not feasible as the cube update times vary.

I have been looking at loads of options on the internet with regards to C8 scedhuling based on occurence or using a trigger however I am feeling like I am heating a dead-end.

Can anyone perhpas who has had this scenario please assist on how I can achieve this and on whether it is something doable or not.

Thanks in advance!

redmist

If you have already automated the Cube build using command line/batch jobs, you would just add another line below it to trigger an event.

You can then schedule the jobs in Cognos Connection based on this trigger

cogtr.exe -n1 -c -g -s -p"MODEL_NAME"

cd\
cd cognos/c8/webapps/utilities/trigger
trigger.bat SERVER_NAME USER_NAME PASSWORD NAMESPACE TRIGGER_NAME

johnpenna

You can fire triggers from server to server...So you can get a ETL job on another server to start a cube build on a different server...You need windows 2003 server on both machines and use the "Schtasks" command in dos

Google Schtasks.exe