backupdefinitionschedules

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 8 of 8 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation