Page 1 of 1

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

Posted: Sun Feb 27, 2005 8:35 pm
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:

Posted: Mon Feb 28, 2005 2:14 am
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

Posted: Mon Feb 28, 2005 2:33 am
by sagarkulkarni_in
u can do this using a a dsjob command on unix prompt.
try using it !!!
Sagar

Posted: Mon Feb 28, 2005 3:46 am
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]

Posted: Mon Feb 28, 2005 3:52 am
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.

Posted: Mon Feb 28, 2005 4:10 am
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

Posted: Mon Feb 28, 2005 4:10 am
by Sainath.Srinivasan
Try jobinfo or report option in dsjob.