Skip to Content
avatar image
Former Member

Question on job history

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 14, 2015 at 04:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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