autosys and datastage

[raji33]

Hi All,

I have a situation where i need to fetch History and comming 30 days job status information from autosys to peoplesoft table, Can any one share their ideas.

Thanks in advance

[kduke]

EtlStats can get job status from the last job run. It can also pull run times and row counts from job log but I doubt if you go back 30 days. most people purge log files more often than that.

Where all tha tis stored in autosys is whole other problem.

[raji33]

Thanks duke for quick reply but iam not getting clear idea like how to design the job

[kduke]

Do a search on EtlStats. It is a free download of some DataStage jobs the extract metadata including run time metadata or "operational" metadata. They will do all the work for you.

[chulett]

Are you looking to get this "30 days job status information" from something stored in Autosys directly or do you just mean you use Autosys to run your DataStage jobs and you are looking for the last 30 days of information from the DataStage logs?

Something like ETLStats will help with the latter, going forward. If you really need historical information from Autosys, you'd need to ask "them" (your Autosys vendor) how one manages to do that.

[raji33]

Hi craig,

Ya , we are using autosys and i have to fetch previous jobs status information and comming 30 days jobs status information from database .

[chulett]

What database? Autosys?

[raji33]

Hi craig ,

Oracle database