on 01-13-2015 4:47 PM
What is the best way to get a list of all jobs in redwood, and the last time they ran? I am trying to get a list of jobs that have been inactive for a long time, to remove them.
I do not know if it is the best way, but you can easily get the history of all your jobs and the start date/time of each execution from the Support Facility url (..../scheduler/support) with this query:
select jd.Name, j.RunStart
from Job j
, JobDefinition jd
where j.JobDefinition = jd.UniqueId
order by jd.Name
Kind Regards, Raul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.