How to get Jobs Completion time in a sequence

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
newie
Participant
Posts: 2
Joined: Sat Aug 11, 2012 1:50 am

How to get Jobs Completion time in a sequence

Post by newie »

I want to extract the Jobs completion time, the Job is not running in my sequence, i just need to extract its End time.

Is there any Macro defined for it like DSJobStartTime ?

Thanks in Advance!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't believe there is a macro for the ending time. However, you could certainly leverage the DSGetJobInfo() function with the (off the top of my head) DSJ.JOBLASTTIMESTAMP InfoType. A routine that establishes a handle to a job could get this for any job, and a Sequence could easily run the routine if that's what you need to do.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply