Hi,
I would like to find out the list of datastage jobs that run before 6 months from the current date. I can hardcode the date/time value..
is there a way I can use some where clause in the below SQL in the adminstrator tool to get that information?
Eg., SELECT COUNT(*) FROM DS_JOBS
please let me know.
Thanks in advance,
Vij
How to find the job run times?
Moderators: chulett, rschirm, roy
So... you're trying to identify jobs that have not run in the last six months?
That information won't be in DS_JOBS but rather in each individual job's RT_STATUSnnn hashed file, I believe. And it is not something that is openly documented but certain people here probably know exactly where that would be.
That information won't be in DS_JOBS but rather in each individual job's RT_STATUSnnn hashed file, I believe. And it is not something that is openly documented but certain people here probably know exactly where that would be.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not RT_CONFIGnnn, but either of RT_LOGnnn or RT_STATUSnnn.
Depends how you want to go about it. You can use the DataStage API (from DataStage or from an external C program), or you can use shell script using dsjob commands.
Depends how you want to go about it. You can use the DataStage API (from DataStage or from an external C program), or you can use shell script using dsjob commands.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Download EtlStats and get row counts for all jobs in a project. There is a job to load ETL_JOB table. You can do an other join fromETL_JOB to ETL_JOB_HIST to get your list. If you want a more complete list there is a job to get row counts from log files. Run it too. This will get row counts on job which have been compiled but the log has not been cleared recently.
Do a search on EtlStats on what it is and how to install it.
Do a search on EtlStats on what it is and how to install it.
Mamu Kim