| CommonDBServer1 |
sp_run |
Enabled |
TSQL |
No description available. |
2019/04/30 04:27:18 PM |
2019/04/30 04:27:18 PM |
CommonDBServer1 |
SQLOLEDB |
CommonDBServer1 |
Verify that automation is enabled. |
IF (msdb.dbo.fn_syspolicy_is_automation_enabled() != 1)
BEGIN
RAISERROR(34022, 16, 1)
END
|
|
|
|
|
Failed |
|
Daily |
Occurs every 1 day(s) |
Occurs once at 02:00:00 |
| CommonDBServer1 |
sp_run_old |
Enabled |
TSQL |
No description available. |
2019/04/30 04:27:18 PM |
2019/04/30 04:27:18 PM |
CommonDBServer1 |
SQLOLEDB |
CommonDBServer1 |
Purge history. |
EXEC msdb.dbo.sp_sp_run |
|
|
|
|
Failed |
|
Daily |
Occurs every 1 day(s) |
Occurs once at 02:00:00 |
| CommonDBServer1 |
sp_run_veryOldJob |
Enabled |
PowerShell |
No description available. |
2019/04/30 04:27:18 PM |
2019/04/30 04:27:18 PM |
CommonDBServer1 |
SQLOLEDB |
CommonDBServer1 |
Erase Phantom System Health Records. |
if ('$(ESCAPE_SQUOTE(INST))' -eq 'MSSQLSERVER') {$a = '\DEFAULT'} ELSE {$a = ''};
(Get-Item SQLSERVER:\SQLPolicy\$(ESCAPE_NONE(SRVR))$a).EraseSystemHealthPhantomRecords()
|
|
|
|
|
Failed |
|
Daily |
Occurs every 1 day(s) |
Occurs once at 02:00:00 |