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 |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.