Job Start TIme and Job End Time

pradkumar · Post by **pradkumar** » Wed Jan 17, 2007 11:59 pm

Hi

I am runing a master sequence. I would like to capture the start time of the job and End time of the job in a file or table.

How to accomplish this?

rleishman · Post by **rleishman** » Thu Jan 18, 2007 12:54 am

A long time ago, I tried running the BuiltIn DSJobReport subroutine as the last activity of a Job Sequence, instead of from the After-Job subroutine of a server job, as is intended.

From memory, it mostly worked, except the status showed as RUNNING, insteead of FINISHED. I chucked in the idea around then. I can't remember whether it showed an accurate Job End Time though. Give it a go.

kumar_s · Post by **kumar_s** » Thu Jan 18, 2007 5:04 am

Find the list of jobs in Jobsequence, and use

Code: Select all

dsjob -report <project> <jobname> BASIC

. Or simple use the Popular EtlStatus from KimDuke homepage.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 18, 2007 3:45 pm

If you use DSGetJobInfo() from an after-job subroutine you can request the "interim status" - that is, the status with which the job will finish assuming it's not aborted by the after-job subroutine's ErrorCode argument.