Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

sysjobschedules System Table - SQL Server 2000

RSS
Modified on Fri, May 01, 2009, 10:59 AM by Administrator Categorized as SQL Server System Tables
Contains schedule information for jobs to be executed by SQL Server Agent. This table is stored in the msdb database.

Column nameData typeDescription
schedule_idintID of the schedule.
job_iduniqueidentifierID of the job.
namesysnameName of the schedule.
enabledintEnabled status of the schedule.
freq_typeintFrequency of the schedule execution: 1 = Once; 4 = Daily; 8 = Weekly; 16 = Monthly; 32 = Monthly relative; 64 = When SQL Server Agent starts
freq_intervalintValue 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; 2 = Monday; 4 = Tuesday; 8 = Wednesday; 16 = Thursday; 32 = Friday; 64 = Saturday. 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; 2 = Monday; 3 = Tuesday; 4 = Wednesday; 5 = Thursday; 6 = Friday; 7 = Saturday; 8 = Day; 9 = Weekday; 10 = Weekend day.
freq_subday_typeintUnits for the freq_subday_interval: 1 = At the specified time; 2 = Seconds; 4 = Minutes; 8 = Hours.
freq_subday_intervalintNumber of freq_subday_type periods to occur between each scheduled execution of the job.
freq_relative_intervalintScheduled 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
freq_recurrence_factorintNumber of weeks or months between the scheduled execution of the job.
active_start_dateintDate to begin executing the job.
active_end_dateintDate to stop executing the job.
active_start_timeintTime to start executing the job.
active_end_timeintTime to stop executing the job.
next_run_dateintDate that the job will next execute.
next_run_timeintTime that the job will next execute.
date_createddatetimeDate the scheduled job entry was created.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.