DSXchange

Hi ,

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

Any help can be appreciated.
thanks in advance

Search

-Kumar

Hi,

From the command window in Datastage Administrator execute the following query.

SELECT DTM, MODFIFIER FROM DS_AUDITS WHERE INSTANCE='Job_Name'

It will give you the creation as well as the modified time of the job.

HTH
--Rich

Hi,
I think Kumar wanted to say...

If it's important enough to post a question regauding this issue
It's important enough to first use the search utility this site offers.

Most answeres are just a search away

richdhan wrote:Hi,

From the command window in Datastage Administrator execute the following query.

SELECT DTM, MODFIFIER FROM DS_AUDITS WHERE INSTANCE='Job_Name'

It will give you the creation as well as the modified time of the job.

HTH
--Rich

No it won't. Date/time created and creator are separate columns. LIST.DICT DS_AUDIT to get column names. Note also that the name of the table does not end in "S".

Hi,
I tried this query at command line but not working. and I searched in the forum also but I couldn't get proper information. Can anybody help me?

thanks in advance.

Hi Ravi,
Try this command, Output:
Instance Id.jobname
Created by...user
Created on...job cration date


regards
kcs

HI Ravi,
As Ray mentioned, use LIST DICT DS_AUDIT to view the structure of the file.
The query you used with DTM will give only the modified time, Created date can be derived only by DTC as kcs mentioned.

-Kumar

Hi Ravi,

Due to network problems I could not connect to Datastage(via Citrix). Just gave the reply from the back of my head.

I usually don't reply without working on the problem using Datastage but yesterday I was just curious to see the charter member logo against my name.

Sorry if I mislead you.

Ray wrote:No it won't. Date/time created and creator are separate columns. LIST.DICT DS_AUDIT to get column names. Note also that the name of the table does not end in "S".

Ray thanks for correcting me.

--Rich

Hi Ravi,

Try this command to find Job Modification Date(s)
SELECT MODIFIER,DTM FROM UNNEST DS_AUDIT ON MODS WHERE CLASS ='2' AND INSTANCE = 'JobName';
Output:
Modifier-------modification Date
user-----------------Date



Regards
kcs

Hi

SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = 'gmt1';

This is working fine. And I have one more doubt regarding this. Suppose I created one job on Feb 2nd in Dev env and moved that job to Producton on 6th Feb. Now If give the above query in Productin admin which date will appear either creation date or moved date. Why I am asking is i am getting only the moved date but i want to see the creation date.

plz help me
thanks in advance.

Ravi,

the audit file is created as an audit trail of actions, so if you copy a job into project X that project sees the file as being created on the date when the job was loaded, not when it was originally created in another project. Along the same lines, any modification history would also not be visible in the new project.

If you need to do this you will have to put your own version and date information into a text field such as the long job description, which is best suited for this.

Hi,

Moved date is the actual creation date for the Production. Because it the first time the job getting catalouged in Production VOC. So the you can only opt some work around. Diverting the output to a file and making use of it in production.

-Kumar

Thanks Arnd n Kumar,
Arnd wrote

If you need to do this you will have to put your own version and date information into a text field such as the long job description, which is best suited for this.

Usually we maintain Version control tool for maintaining the job modifications.
Other than version control tool, Can we do this thru datastage or do it manually?
thanks in advance.

Version Control will include the date/time promoted information in the long text description field of a job, so that won't help you. I would suggest that you manually enter a fixed-format text that you can parse out of the text, such as "Job Created on yyyy-mm-dd" to store that information.