SELECT * FROM msdb..sysdbmaintplan_history Results:
|
sequence_id |
plan_id |
plan_name |
database_name |
server_name |
activity |
succeeded |
end_time |
duration |
start_time |
error_number message |
|
|
1 |
22F70D58-642D-44F9-80A3-17A5D2E776DF |
Northwind |
Northwind |
W15KC |
Rebuild Indexes |
1 |
2001-12-05 19:45:04.793 |
3 |
2001-12-05 19:45:01.793 |
0 |
|
|
2 |
22F70D58-642D-44F9-80A3-17A5D2E776DF |
Northwind |
Northwind |
W15KC |
Shrink Database |
1 |
2001-12-05 19:45:04.833 |
0 |
2001-12-05 19:45:04.833 |
0 |
|
|
3 |
22F70D58-642D-44F9-80A3-17A5D2E776DF |
Northwind |
Northwind |
W15KC |
Check Data and Index Linkage |
1 |
2001-12-05 19:46:01.607 |
1 |
2001-12-05 19:46:00.607 |
0 |
|
|
4 |
22F70D58-642D-44F9-80A3-17A5D2E776DF |
Northwind |
Northwind |
W15KC |
Backup database |
1 |
2001-12-05 19:47:04.677 |
4 |
2001-12-05 19:47:00.677 |
0 |
Backup Destination: [C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Northwind\Northwind_db_200112051947.BAK] |
|
5 |
22F70D58-642D-44F9-80A3-17A5D2E776DF |
Northwind |
Northwind |
W15KC |
Verify Backup |
1 |
2001-12-05 19:47:05.510 |
1 |
2001-12-05 19:47:04.510 |
0 |
|