Extracting the list of jobs that are failed in a server

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
saj
Participant
Posts: 30
Joined: Fri Aug 28, 2009 6:00 am

Extracting the list of jobs that are failed in a server

Post by saj »

Hi All ,
Can any one please tell me when a job fails where the details will be saved .
For eg : In the server ABC if 20 jobs has failed at the same time will this information be saved in any place .
If so can we retrieve the information like which all jobs has failed .
Rather than going into DS director or job status do we have any command which we can fire and get all the list of jobs tat are failed in a server.
arvind_ds
Participant
Posts: 428
Joined: Thu Aug 16, 2007 11:38 pm
Location: Manali

Post by arvind_ds »

May be you can write a routine to capture the details of the aborted DS jobs in a particular project.
Arvind
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There no special list somewhere, those details are stored with each job. You only option is to iterate through a list of all jobs in the project and check, one by one, for whatever condition it is you are looking for.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Open Director. Disable display of categories. Sort by status. Select the aborted jobs and adjust the window so that only these are showing. From the Project menu choose Print, within the print dialog choose print to file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply