cancel
Showing results for 
Search instead for 
Did you mean: 

Question on job history

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

nanda_kumar21
Active Contributor
0 Kudos

hey cindy,

you can use Raul's query and order by date and select top 1 to get the last time the job ran.

you can use redwood script job definition to do that.

thanks

Nanda