IntelliMatch – How to find associated Calendar with Job

The easiest way to find out if a calendar has been associated with a job without going through each and every job is to look at the value in “Calendar” column of the “ScheduledJob” table. A value of -1 indicates that there is no calendar associated with the job whereas any other value would correspond to the calendar set up for which you can refer to the Calendars table.