Job Abort

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
VasanthRM
Participant
Posts: 37
Joined: Wed May 11, 2005 3:05 am

Job Abort

Post 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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post 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?
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Reset and run immediately after a job failure is not adviced. It will lead to more problem than answers.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post 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.
Mamu Kim
VasanthRM
Participant
Posts: 37
Joined: Wed May 11, 2005 3:05 am

Post 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.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Mamu Kim
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Mamu Kim
Post Reply