How to list jobs modification dates?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Another solution is to use Metadata Workbench and just run a query for the Job object and list the Last Modified Date and Last Modified By values.....
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Hi,
I tested the jobs listed in DS_AUDIT table against the result obtained from advanced find today and found out that both the methods list different jobs.
For e.g. - I queried DS_AUDIT table -
SELECT @ID FORMAT '80L' FROM DS_AUDIT WHERE DTM LIKE '2010-11-02%';
and searched the modified jobs in advanced find where last modified is today.
I got job1, job2, job3 as a result of query and job2, job3, job4 as a result of advanced find.
Is there any other way in which we can list the modified jobs wrt a particular day? Can you tell me what populates the advanced find results? What are the tables used to get the search result in advanced find?
Thanks in advance !!!
I tested the jobs listed in DS_AUDIT table against the result obtained from advanced find today and found out that both the methods list different jobs.
For e.g. - I queried DS_AUDIT table -
SELECT @ID FORMAT '80L' FROM DS_AUDIT WHERE DTM LIKE '2010-11-02%';
and searched the modified jobs in advanced find where last modified is today.
I got job1, job2, job3 as a result of query and job2, job3, job4 as a result of advanced find.
Is there any other way in which we can list the modified jobs wrt a particular day? Can you tell me what populates the advanced find results? What are the tables used to get the search result in advanced find?
Thanks in advance !!!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray,
I want to know if there is any table other than DS_AUDIT from which I can extract job modification information. As I didnt receive any response to my previous question I asked information on how to list the tables in administrator client.
Why I need this information?
This is because I am working on a script which works on a daily basis and backs up all the jobs modified till the end of day.
STEP 1. The script attaches to a project.
STEP 2. Lists the jobs modified in that particular project.
STEP 3. Backs up jobs wrt list obtained at STEP 2
The entire script is ready but the only thing in which I am lagging is "how to get the job list in STEP 2". I tried querying DS_AUDIT but the jobs obtained were different than that obtained while using the Datastage Designer "Advanced Find" option.
Please advise on the same.
I want to know if there is any table other than DS_AUDIT from which I can extract job modification information. As I didnt receive any response to my previous question I asked information on how to list the tables in administrator client.
Why I need this information?
This is because I am working on a script which works on a daily basis and backs up all the jobs modified till the end of day.
STEP 1. The script attaches to a project.
STEP 2. Lists the jobs modified in that particular project.
STEP 3. Backs up jobs wrt list obtained at STEP 2
The entire script is ready but the only thing in which I am lagging is "how to get the job list in STEP 2". I tried querying DS_AUDIT but the jobs obtained were different than that obtained while using the Datastage Designer "Advanced Find" option.
Please advise on the same.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no other single table on the server. There may well be this information stored in the unified metadata repository (XMETA) but the structure of those tables is not in the public domain.
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.