How to get the date of job creation

ravij · Post by **ravij** » Sun Feb 05, 2006 10:22 pm

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

kumar_s · Post by **kumar_s** » Sun Feb 05, 2006 10:40 pm

Search

-Kumar

richdhan · Post by **richdhan** » Mon Feb 06, 2006 3:29 am

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

roy · Post by **roy** » Mon Feb 06, 2006 6:08 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Feb 06, 2006 2:00 pm

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".

ravij · Post by **ravij** » Tue Feb 07, 2006 12:41 am

Hi,

Code: Select all

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

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.

kcshankar · Post by **kcshankar** » Tue Feb 07, 2006 12:57 am

Hi Ravi,
Try this command,

Code: Select all

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

Output:
Instance Id.jobname
Created by...user
Created on...job cration date

regards
kcs

kumar_s · Post by **kumar_s** » Tue Feb 07, 2006 1:36 am

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

richdhan · Post by **richdhan** » Tue Feb 07, 2006 2:46 am

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

kcshankar · Post by **kcshankar** » Tue Feb 07, 2006 5:56 am

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

ravij · Post by **ravij** » Wed Feb 08, 2006 5:55 am

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.

ArndW · Post by **ArndW** » Wed Feb 08, 2006 6:04 am

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.

kumar_s · Post by **kumar_s** » Wed Feb 08, 2006 6:06 am

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

ravij · Post by **ravij** » Wed Feb 08, 2006 10:55 pm

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.

ArndW · Post by **ArndW** » Thu Feb 09, 2006 1:53 am

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.