Knowing the timestamp of jobs/sequencers

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
Victoria
Participant
Posts: 21
Joined: Mon Nov 12, 2007 1:44 pm

Knowing the timestamp of jobs/sequencers

Post by Victoria »

Hi,
How will I know when a job or sequencer is last updated or created? Is there a DS table I can query for this?

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

Post by chulett »

The Manager will show you last modified. Search the forums for DS_AUDIT for examples of what activities are tracked by DataStage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Knowing the timestamp of jobs/sequencers

Post by gateleys »

You can query the DS_AUDIT table for column DTM. Use column INSTANCE to restrict the search to your JobName.
gateleys
Top
Post Reply

Return to “General”