How to clear the job status

vinoth venkitapathy · Sun Aug 09, 2009 11:30 pm

Hi,
our's is a server sequence job and it is run by a shell script.The script has the restartability function that is, the script reads the last run status from the jobstaus in the source path and triggers the last failed job if the sequencer has aborted otherwise it will start from the beginning.Now we want to run the sequencer from the starting eventhough last run has failed,is there any command to clear the status of the job?

ray.wurlod · Post by **ray.wurlod** » Sun Aug 09, 2009 11:54 pm

From the command line (script), no.

You could recompile the jobs, using dscc, but that's not the same as clearing the status even though it has that as one of its effects.

But are you permitted to recompile in production?!!! Not at any site I run.

chulett · Post by **chulett** » Mon Aug 10, 2009 6:06 am

You should, however, be able to reset the job from the command line to the same effect. Can't check the actual syntax from here at the moment.

keshav0307 · Post by **keshav0307** » Tue Aug 11, 2009 8:23 am

CLEAR.FILE RT_STATUSxxxxxx

ray.wurlod · Post by **ray.wurlod** » Tue Aug 11, 2009 4:30 pm

Not from a script (without being wrapped in an invocation of a DataStage shell).