Skip to main content

Pull All Scheduler Tables and Cancel Scheduler

SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_BLOB_TRIGGERS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_CRON_TRIGGERS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_FIRED_TRIGGERS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_JOB_DETAILS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_LOCKS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_PAUSED_TRIGGER_GRPS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_SCHEDULER_STATE
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_SIMPLE_TRIGGERS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_SIMPROP_TRIGGERS
SELECT * FROM [dbo]. SchedulerTestProject_QRTZ_TRIGGERS

It can be used by changing the project name information, and all Scheduler data on the project can be viewed. To cancel the Scheduler on a project, a DELETE query is thrown to these tables. Example:

DELETE FROM [dbo]. SchedulerTestProject_QRTZ_TRIGGERS