command to get the job creation date

[suresh.narasimha]

Hi

Could anybody help me to get the
command to get the job creation date.

Is any possibility to change the creation date of job.If so how to trace that who changed the creation date.

This would be a great help.

thanks in Advance

Suresh N

[ArndW]

There is no date field embedded in the designtime information of a job, but you can look at the DS_AUDIT table in the project repository. That file will give you an audit trail of the change history for your jobs, among other information.

The DS_AUDIT table is not described or documented and does contain fields that are "multivalued" but the file itself is not overly complex and contains all the information you want.

[ray.wurlod]

Since you're new to the forum, and I'd guess even newer to DataStage SQL (especially for multi-valued fields), here's a starter pair of queries.

Code: Select all

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

SELECT MODIFIER, DTM
FROM UNNEST DS_AUDIT ON MODS
WHERE CLASS = '2' AND INSTANCE = '<<JobName>>';

[just4geeks]

This really helped me! Thanks Ray!