DSXchange

Posted: **Wed Dec 03, 2008 3:02 am**

Hi All,

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

thanks
fareeda

Posted: **Wed Dec 03, 2008 3:30 am**

In Transformer ---> DSmacro --> DSJobStartDate

Posted: **Wed Dec 03, 2008 5:16 am**

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

SELECT DTC, CREATOR FROM DS_AUDIT WHERE CLASS = '2' AND INSTANCE = '<<Job Name>>';