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!
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
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