job creation date

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
fareeda_b
Participant
Posts: 48
Joined: Sat Feb 23, 2008 4:25 pm

job creation date

Post by fareeda_b »

Hi All,

I want to see the job creation date. How can I see it? Is there any command for that?



thanks
fareeda
Thanks
srinivas.g
Participant
Posts: 251
Joined: Mon Jun 09, 2008 5:52 am

Post by srinivas.g »

In Transformer ---> DSmacro --> DSJobStartDate
Srinu Gadipudi
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, that's when the job most recently started. You get the creation date from the DS_AUDIT table.

Code: Select all

SELECT DTC, CREATOR FROM DS_AUDIT WHERE CLASS = '2' AND INSTANCE = '<<Job Name>>';
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply