How can I trap the status from dsjob?

videsh77 · Post by **videsh77** » Thu May 12, 2005 10:56 am

1. I dont want to run a job, if it is in aborted state. I need to trap this before executing 'dsjob' from command prompt.

2. Also, I want to detect that job have been completed successfully, & need to trap that code, that the job has finished.

Can anyone has idea, how we can achieve this?

ray.wurlod · Post by **ray.wurlod** » Thu May 12, 2005 5:38 pm

First call is to dsjob with -jobinfo. This returns the status. You can then make the decision about whether to use the -run option (perhaps with run mode RESET?).

chulett · Post by **chulett** » Thu May 12, 2005 8:27 pm

In other words, a shell script 'wrapper' that does all this before actually running the job for real. All kinds of checking can go on.

As Ray noted, first thing is to use -jobinfo to check the current status of the job - including if it even exists. If the job needs to be reset, another call to dsjob with the -run -mode RESET that Ray mentioned will do the trick.

Running the job with the -wait option will cause the command to wait until the job finishes before moving to the next step. I prefer using the -jobstatus option instead as it does the same waiting but returns 'DataStage codes': 1 = Ok, 2 = Warnings, 3 = Aborted, etc.

We also shift through the parameters passed to the wrapper script to build the appropriate -param statements the job may need.

Try running jobs with various variations of these commands yourself from the command line so you'll become familiar with what they return, good and bad. That way you'll know what to trap.

videsh77 · Post by **videsh77** » Thu Jun 02, 2005 3:52 am

Chulette

I am not able to locate -jobstatus, as an option to dsjob. Let me share the command what I gave :

dsjob -server $server -user $user -password $password -jobstatus DSRepName DSJobName

I am getting - Invalid/unknown primary command switch.

We have requirement, to wait until job finishes & retirieve the status.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2005 5:24 am

The -jobstatus option is used as a suboption with the -run main option. The actual option you require is -jobinfo.

videsh77 · Post by **videsh77** » Thu Jun 02, 2005 5:32 am

Thank you very much.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2005 5:34 am

This is actually what Craig said, if you re-read his post carefully.