How to get the date of job creation
Moderators: chulett, rschirm, roy
How to get the date of job creation
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
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
Ravi
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
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
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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".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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
Code: Select all
SELECT DTM, MODFIFIER FROM DS_AUDITS WHERE INSTANCE='Job_Name'
thanks in advance.
Ravi
Hi Ravi,
Try this command,
Output:
Instance Id.jobname
Created by...user
Created on...job cration date
regards
kcs
Try this command,
Code: Select all
SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = 'gmt1';
Instance Id.jobname
Created by...user
Created on...job cration date
regards
kcs
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.
--Rich
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 thanks for correcting me.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".
--Rich
How to get the date of job creation
Hi
plz help me
thanks in advance.
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.SELECT INSTANCE,CREATOR,DTC FROM DS_AUDIT WHERE CLASS ='2' AND INSTANCE = 'gmt1';
plz help me
thanks in advance.
Ravi
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
How to get the date of job creation
Thanks Arnd n Kumar,
Arnd wrote
Other than version control tool, Can we do this thru datastage or do it manually?
thanks in advance.
Arnd wrote
Usually we maintain Version control tool for maintaining the job modifications.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.
Other than version control tool, Can we do this thru datastage or do it manually?
thanks in advance.
Ravi
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>