I have been looking for a way to generate a report of all jobs that have been executed in a project in the last 90 days. I know all the jobs are not running and I want to clean up the environment by removing the jobs that have not been executed in a while. Please help or point me to a discussion that may answer my question. Thanks.
Jay.
How can I get a report of all executed jobs in a project?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 7
- Joined: Wed Feb 14, 2007 12:57 pm
There are a number of conversation here on that topic which a search for "jobinfo" may turn up. If you want to do this from the command line, look into the -jobinfo for dsjob. From a job, the DSGetJobInfo function would be the equivalent. You'd need to parse the last run date from the output and then decide if it fit your reporting criteria.
Both "sides" support the same set of functions, at a high level you could get a list of all projects on the server, then iterate thru the list of projects to get a list of jobs and then issue the job info check on each one.
Both "sides" support the same set of functions, at a high level you could get a list of all projects on the server, then iterate thru the list of projects to get a list of jobs and then issue the job info check on each one.
-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:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 7
- Joined: Wed Feb 14, 2007 12:57 pm