CMSSQLJOBSCHEDULES

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
BUSINESSPROCESSID	uniqueidentifier	yes
JOBNAME	nvarchar(400)		Default = ''
DESCRIPTION	nvarchar(500)		Default = ''
SCHEDULEFREQUENCYTYPE	int		Default = 4
SCHEDULEONCEDATE	datetime	yes
SCHEDULEONCETIME	datetime	yes
SCHEDULEFREQUENCYMONTHLYINTERVAL	int		Default = 0
SCHEDULEFREQUENCYEVERY	int		Default = 1
SCHEDULEFREQUENCYINTERVAL	int		Default = 1
SCHEDULEWEEKLYMONDAY	bit		Default = 0
SCHEDULEWEEKLYTUESDAY	bit		Default = 0
SCHEDULEWEEKLYWEDNESDAY	bit		Default = 0
SCHEDULEWEEKLYTHURSDAY	bit		Default = 0
SCHEDULEWEEKLYFRIDAY	bit		Default = 0
SCHEDULEWEEKLYSATURDAY	bit		Default = 0
SCHEDULEWEEKLYSUNDAY	bit		Default = 0
SCHEDULEFREQUENCYMONTHLYISRELATIVE	bit		Default = 0
ENABLESCHEDULE	bit		Default = 0
SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL	int		Default = 1
SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY	int		Default = 8
SCHEDULEFREQUENCYSUBDAYTYPE	int		Default = 8
SCHEDULEFREQUENCYSUBDAYISRELATIVE	bit		Default = 0
SCHEDULEFREQUENCYSUBDAYINTERVAL	int		Default = 0
SCHEDULEACTIVESTARTTIME	datetime	yes
SCHEDULEACTIVEENDTIME	datetime	yes
SCHEDULEACTIVESTARTDATE	date	yes
SCHEDULEACTIVEENDDATE	date	yes
SCHEDULENOENDDATE	bit		Default = 1
RECORDID	int		Default = 0
ONHEARTBEAT	bit		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CMSSQLJOBSCHEDULES_DATEADDED	DATEADDED			yes
IX_CMSSQLJOBSCHEDULES_DATECHANGED	DATECHANGED
PK_CMSSQLJOBSCHEDULES	ID	yes	yes

Triggers

Trigger Name	Description
TR_CMSSQLJOBSCHEDULES_AUDIT_UPDATE
TR_CMSSQLJOBSCHEDULES_AUDIT_DELETE