Kick off job based on table entry

vinaymanchinila · Post by **vinaymanchinila** » Mon Jan 15, 2007 12:49 pm

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,

narasimha · Post by **narasimha** » Mon Jan 15, 2007 1:04 pm

It should be achievable.
Get a list of your jobs into a file and pass it as a parameter to UtilityRunJob
Check this post

vinaymanchinila · Post by **vinaymanchinila** » Mon Jan 15, 2007 1:15 pm

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 !

DSguru2B · Post by **DSguru2B** » Mon Jan 15, 2007 1:15 pm

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.

DSguru2B · Post by **DSguru2B** » Mon Jan 15, 2007 1:17 pm

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().