COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: bhanu.samas on 22 Jun 2012 08:31:10 AM

Title: How to schedule a Cognos Data Manager job on windows scheduler?
Post by: bhanu.samas on 22 Jun 2012 08:31:10 AM
Hi,
Can anyone please assist me in scheduling cognos data manager jobs on windows scheduler on client machine itself. Because there is a problem with the network services so thats why we are unable to run jobs on Cognos Server.

Thanks,

-Bhanu
Title: Re: How to schedule a Cognos Data Manager job on windows scheduler?
Post by: MFGF on 22 Jun 2012 10:01:31 AM
Sure. Which bit are you struggling with?

If you launch the Data Manager designer and open your catalog, you can right-click a jobstream and choose the "Execute" option. This will display a dialog from which you can set execution options, but more importantly it will display the command line syntax for launching the jobstream from the command line. Copy this syntax, then cancel the Execute dialog.

Now create yourself a batch file and paste this command into it. Hint - if there is a -P switch in the command syntax, remove it, as this will result in a pause saying "press return to continue" at the end of the job.

If you have other jobstreams you want to fire off, copy their command line syntax into the batch file too.

Then schedule the batch file to run using your windows scheduler ('at' or similar)

Let us know if you have any specific questions along the way.

MF.
Title: Re: How to schedule a Cognos Data Manager job on windows scheduler?
Post by: bhanu.samas on 22 Jun 2012 02:20:56 PM
Thanks for the reply.  We have installed DM Designer on windows and DM Engine, Network Services on Linux with the cognos BI server. We have issues when running the DM jobs remotely on the sever. we are getting DM-NTC-0008 connection could not be made to the target machine error.

Could you please help.
Title: Re: How to schedule a Cognos Data Manager job on windows scheduler?
Post by: bhanu.samas on 22 Jun 2012 02:35:17 PM
I tried copying th command line syntax and ran it as a batch file. but it's not working.
"c:\program files\ibm\cognos\c10dm\bin\dsremote.exe" "dm client name" -P "databuild" "ORACLE" "userid/~E66AE90E228E9BAD0052AACAD434007189@oracledb" "build name" -XFD
could you please help.
Title: Re: How to schedule a Cognos Data Manager job on windows scheduler?
Post by: MFGF on 25 Jun 2012 05:19:09 AM
Does it work when you run it from within the Data Manager designer? If not, it's not an issue with scheduling - it means you don't have your remote access set up properly.  I notice you didn't remove the -P switch from the command either - you will need to do this before you put the command into a schedule or a batch file or else the processes will never complete (assuming you get your remote access issue sorted first.

Regards,

MF.