How to get Job start and end time

arunverma · Post by **arunverma** » Mon Sep 12, 2005 4:13 am

Hi ,

We are having two dept. , development and operation . development team develop application and create root job sequencer , this sequencer call one by one all job . operation team is responsible to run application's sequencer . on daily basis they send us application wise status report , like finished , job start time endtime etc . to do this type of status report , they login DS Director and find individual root job sequencer start and end time .

Can any body help me how to get job status , start time and end time from universe for a given date .

Regards

Arun Verma

ray.wurlod · Post by **ray.wurlod** » Mon Sep 12, 2005 4:56 am

That is a very complex query, Arun, since the start and end times are stored in a different table for every job. Further, I believe your site uses multiple job instances, which roughly doubles the complexity.

You would be better off creating DataStage componentry to extract this information; a set of routines that could query the log for a particular job and store that information, and perhaps a job or routine that processes some or all of the jobs in the project.

arunverma · Post by **arunverma** » Mon Sep 12, 2005 5:16 am

Thanks Mr. Ray ,

Can you Pl guide , how to get info and from which table , so we can start developing routine .

Reagrds

Arun Verma

ray.wurlod · Post by **ray.wurlod** » Mon Sep 12, 2005 3:49 pm

DS_JOBS contains all the job names and job numbers.
RT_LOGnnn contains the log for job number nnn.

Use DSGetNewestLogId() to find the closest event number to the timestamp in question. Then cycle backwards till you find "job started" or "job finished" event. From this you will be able to determine the status.

You guys know all this stuff! Look at your training materials from 2003.

kduke · Post by **kduke** » Mon Sep 12, 2005 8:33 pm

Download EtlStats from my tips page.

Should have a Windows version soon. Got everything but email working. Changed everything to ODBC. Should be lots easier to install.

arunverma · Post by **arunverma** » Mon Sep 12, 2005 11:23 pm

Thanks to all , I am going to start routine , I will let you if any issue .

Regards

Arun Verma