How to list jobs modification dates?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 19, 2010 3:41 pm

Assuming a default installation, C:\IBM\InformationServer\Server\DSEngine\bin\dssh.exe

synsog · Post by **synsog** » Wed Oct 20, 2010 1:47 am

Our server is on AIX. We only have clients installed on our machines. Is there any way in which I can contact the AIX server thru my batch script and get the desired result? Some tool other than uvsh and dssh.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 20, 2010 2:49 am

No. You can use the Administrator client, but you can't script commands to be run through that interface.

synsog · Post by **synsog** » Wed Oct 20, 2010 3:43 am

Thank you all for the support.

chulett · Post by **chulett** » Wed Oct 20, 2010 7:32 am

synsog wrote:Our server is on AIX.

And yet your first post categorized it as a Windows server, hence the replies you received. I've corrected that.

eostic · Post by **eostic** » Wed Oct 20, 2010 9:23 am

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

synsog · Post by **synsog** » Thu Nov 04, 2010 8:22 am

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 !!!

synsog · Post by **synsog** » Wed Nov 10, 2010 8:15 am

How can I find out all the tables listed in administrator client?

Is there any show tables or any other command which might save my purpose?

ray.wurlod · Post by **ray.wurlod** » Wed Nov 10, 2010 3:04 pm

I really don't think that question relates to job modification dates? Please begin a new thread.

synsog · Post by **synsog** » Thu Nov 11, 2010 5:43 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 11, 2010 3:06 pm

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.