Page 1 of 1

How to clear the job status

Posted: Sun Aug 09, 2009 11:30 pm
by vinoth venkitapathy
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?

Posted: Sun Aug 09, 2009 11:54 pm
by ray.wurlod
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.

Posted: Mon Aug 10, 2009 6:06 am
by chulett
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.

Posted: Tue Aug 11, 2009 8:23 am
by keshav0307
CLEAR.FILE RT_STATUSxxxxxx

Posted: Tue Aug 11, 2009 4:30 pm
by ray.wurlod
Not from a script (without being wrapped in an invocation of a DataStage shell).