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.
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.
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers