Want to see the status of executed jobs in a text file.

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
Shri
Participant
Posts: 10
Joined: Fri Nov 19, 2004 2:21 pm

Want to see the status of executed jobs in a text file.

Post by Shri »

Hi,
Am running a set of jobs, through scheduling or by running it through a sequencer, i want the staus of the jobs in a text file, means the Finished, Failed satus etc., in a text file.. how can i do this.. also please tell me more about DS_JOBOBJECTS and DS_JOBS....

thnx in advance..

Shri :roll:
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

with dsjob job can request information from DataStage. Write a Windows-programm with you favourite language and ask DataStage and write it to a file

Wolfgang
sagarkulkarni_in
Participant
Posts: 11
Joined: Sun Jan 30, 2005 11:42 pm

Post by sagarkulkarni_in »

u can do this using a a dsjob command on unix prompt.
try using it !!!
Sagar
Shri
Participant
Posts: 10
Joined: Fri Nov 19, 2004 2:21 pm

Post by Shri »

[quote="sagarkulkarni_in"]u can do this using a a dsjob command on unix prompt.
try using it !!!
Sagar[/quote]



am using windows. so can u please help me how i can get the status in a separate file.. can any one say the commands to get the status of all the jobs in a category, so that if i run a general job, it should give the status of all the jobs in a text file.[/quote]
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Shri,

see my response to your other thread on the same subject. The documentation describes in detail what options the dsjob command line call has, including listing all sorts of logging information to the screen, which you can redirect under Windoze to a text file much as you would do under unix.
sagarkulkarni_in
Participant
Posts: 11
Joined: Sun Jan 30, 2005 11:42 pm

Post by sagarkulkarni_in »

Hi Shri,

On your dos prompt, go in the directory where DatStage is installed.
Find for "dsjob". Probably you will find it in bin directory in DatSatge\DSEngine.

Go to that directory where dsjob is available and type following command:-

dsjob -jobinfo PROJECTNAME JOBNAME > FILENAME

Let me know if this works.
If this works then we can proceed further.

Sagar
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Try jobinfo or report option in dsjob.
Post Reply