Contains schedule information for jobs to be executed by SQL Server Agent. This table is stored in the msdb database.
|Column name||Data type||Description|
|schedule_id||int||ID of the schedule.|
|job_id||uniqueidentifier||ID of the job.|
|name||sysname||Name of the schedule.|
|enabled||int||Enabled status of the schedule.|
|freq_type||int||Frequency of the schedule execution:
1 = Once
|freq_interval||int||Value indicating on which days the schedule runs.
If freq_type is 4 (daily), the value is every freq_interval days.
If freq_type is 8 (weekly), the value is a bitmask indicating the days in which weekly schedules are run. The freq_interval values are:
1 = Sunday
If freq_type is 16 (monthly), the value is freq_interval day of the month.
If freq_type is 32 (monthly relative), freq_interval can be one of these values:
1 = Sunday
|freq_subday_type||int||Units for the freq_subday_interval:
1 = At the specified time
|freq_subday_interval||int||Number of freq_subday_type periods to occur between each scheduled execution of the job.|
|int||Scheduled job's occurrence of the freq_interval in each month when freq_type is 32 (monthly relative): |
1 = First
2 = Second
4 = Third
8 = Fourth
16 = Last
|int||Number of weeks or months between the scheduled execution of the job.|
|active_start_date||int||Date to begin executing the job.|
|active_end_date||int||Date to stop executing the job.|
|active_start_time||int||Time to start executing the job.|
|active_end_time||int||Time to stop executing the job.|
|next_run_date||int||Date that the job will next execute.|
|next_run_time||int||Time that the job will next execute.|
|date_created||datetime||Date the scheduled job entry was created.|