Page 1 of 1

Kick off job based on table entry

Posted: Mon Jan 15, 2007 12:49 pm
by vinaymanchinila
Hi,
We have a scenario where we need to kick off a job if the job name is populated in a table, did any one had a smiliar situation,

basically a table is populated (clear and load) every day with job names, if the DS job name is present in the table that needs to be kicked off, we are using ControlM as the scheduling tool.

Thanks,

Posted: Mon Jan 15, 2007 1:04 pm
by narasimha
It should be achievable.
Get a list of your jobs into a file and pass it as a parameter to UtilityRunJob
Check this post

Posted: Mon Jan 15, 2007 1:15 pm
by vinaymanchinila
Hi,
If lets say there are 5 jobs that are required to be run but in a specific sequence, can we control that too, I am looking in to the UtilityRunJob, but trying to understand the design to in corporate the job dependencies.

Thanks !

Posted: Mon Jan 15, 2007 1:15 pm
by DSguru2B
UtilityRunJob() is just present in server i believe, not too sure, dont have access to DS right now so cannot validate that. Populate the table into a flat file, have a small shell script read that file line by line and pass the jobname to dsjob command. You can control this in a sequence job.

Posted: Mon Jan 15, 2007 1:17 pm
by DSguru2B
vinaymanchinila wrote:Hi,
If lets say there are 5 jobs that are required to be run but in a specific sequence, can we control that too, I am looking in to the UtilityRunJob, but trying to understand the design to in corporate the job dependencies.

Thanks !
Yes it can be controlled. Depends upon what sequence fed to the UtilityRunJob().