Verify SQL Server Database (Advanced Users Only)

Advanced users that are comfortable executing SQL queries can run queries to see the items that are scheduled and their statuses.

One Time Scheduled Items Status

For items that execute one time, use this query and replace [My Scheduled Item] with the name of the Scheduled Item you're looking for:

select DefName, ExecutionType, NextDT, Status, ErrorMsg from TrebuchetScheduler where DefName = 'My Scheduled Item'

and ExecutionType = 'OneTime' order by NextDT

Recurring Scheduled Items Status

For items that are recurring use this query and replace [My Scheduled Item] with the name of the Scheduled Item you're looking for:

select DefName, ExecutionType, NextDT, Status, ErrorMsg from TrebuchetScheduler where DefName = 'My Scheduled Item'

and (ExecutionType = 'Recurring') and (Instance > 0) order by NextDT