DSXchange

hey guys,
I just want to check whether the jobs in a category are runnable state or not. i know we can check in datastage director but how can i do in unix using scripts. If they are in runnable state, i need to run the sequence or else need to compile the jobs and run the sequence. this is all has to be done in unix.
please help to write the script.

Why not just let your JobActivity stage use the Reset if required the run action?

WHY does it all have to be done in UNIX?!!

Parse the output from dsjob -jobinfo

Helping you to write the script, well, that's "professional services" and attracts a fee. Particularly since the requirement is regarded as silly.

The shell script to reset and then run is viewtopic.php?t=93365&highlight=RunJob

Thanks guys.. you are helping a lot.

kool_cons wrote:or else need to compile the jobs and run the sequence. this is all has to be done in unix.

You can't compile jobs from a Unix script.

Which is why the script does a 'reset' instead.

kDuke,
I have a question on your script for resetting a job. Your script will work for one job.but i want to do the same thing for a set of jobs in a category since it is messy to write the same thing for all the jobs. what could be included in the script to do this.

The dsjob command does not have an option to return a list of jobs in a category. I think you've "lucked out" on this requirement.

You can modify that script to reset and run any job. Ray is correct in saying to reset every job in a category is not worth it.

We do not mind helping you but try to be specific. Do not change your requirements in mid stream. We are doing this for fun. We do not get paid to answer these questions or do your job. When it becomes work and not fun then guys like Hester and Bland quit answering questions. Don't try to chase the rest of us off. We really do like to help. Make your best effort then ask when you get truly stuck. We will be glad to help.

i am new to datastage.so i am getting wierd questions.i am sorry guys.i appreciate ur help