Page 1 of 1

Job Abort

Posted: Thu Jun 16, 2005 5:44 am
by VasanthRM
Hi,

Is there any way to automatically reset and start the job on any abort or failure. That can reduce a bit of manual intevention into the system.
will the batch job that sequence these can handle them without going on aborted state.

Is there any way look the log details other then director. Is these mesages saved in any files or tables. If so where can i find them.

Posted: Thu Jun 16, 2005 6:10 am
by ArndW
VasanthRM,

you can specify an automated reset-before-run when calling a job activity in a sequence. If you start the jobs from outside of DataStage from a command line you can use the -mode reset instead of -mode normal to reset the status before running a job.

The subject of job logs has been handled exhaustively in many posts on this forum. Using the search facility will give you a lot of detailed information.

Posted: Thu Jun 16, 2005 6:34 am
by roy
Hi,
Did you mean just reset before next run (which Arnd Answered) or did you want a way to retry a failed run automatically?

Posted: Thu Jun 16, 2005 6:37 am
by Sainath.Srinivasan
Reset and run immediately after a job failure is not adviced. It will lead to more problem than answers.

Posted: Thu Jun 16, 2005 5:31 pm
by kduke
Do a search. I posted code to do this in BASIC and in a shell script. If you cannot find it then let us know.

Posted: Sun Jun 19, 2005 3:25 am
by VasanthRM
Hi Kim,

Thank You. But unable to find the BASIC or Shell Script code. I am not exposed much in coding shell script for DataStage.

Posted: Sun Jun 19, 2005 11:25 am
by kduke

Posted: Sun Jun 19, 2005 11:27 am
by kduke