Mar 11, 2014
SQL Jobs - Complete Information - SQL 2000/2005/2008/R2
SQL Jobs – Complete Information – SQL 2000/2005/2008/R2
SQL Job details – The script can be executed across all SQL version from SQL 2000 onwards.
The below are the columns listed in the output
ServerName
ScheduleID
ScheduleName
IsEnabled
ScheduleType
Occurrence
Recurrence
Frequency
ScheduleUsage
StartDate
ScheduleUsage
EndDate
ScheduleCreatedOn
ScheduleLastModifiedOn
For more information about the columns refer the below the link
http://technet.micr…
View On WordPress