backupdefinitionschedules

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DefScheduleID INT 10 √ null
v_xr_backup_atrisk.DefScheduleID Implied ConstraintR
v_xr_backup_jobhistory.DefScheduleID Implied ConstraintR
v_xr_backup_jobs.DefScheduleID Implied ConstraintR
DefinitionGUID VARCHAR 36 null
JobTypeID INT 10 null
l_backupjobtype.JobTypeId Implied ConstraintR
JobSubTypeID INT 10 null
Schedule VARCHAR 1024 null
FirstRun DATETIME 19 √ null
LastRun DATETIME 19 √ null
IsOldSchedule BIT 1 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc DefScheduleID
DefinitionGUID Performance Asc DefinitionGUID

Relationships

Close relationships within degrees of separation