Molto ben nascosto... ma c'è!!!
...These SQL maintenance jobs provide automated tasks such as database or transaction logs backup, performing database optimization like Index defrag or update statistics, cleaning MSDB backup history and recycling the SQL error log. Each of these jobs runs stored procedures that are installed when the jobs are created.
The following are the jobs get installed with this package.
- SQLBackupAll
- SQLBackupDiffAll
- SQLBackupTranAll
- SQLBackupChecker
- SQLDBCCAll
- SQLIndexDefragAll
- SQLUpdateStatistics
- SQLCleanupMsdbBackupHistory
- SQLCycleErrorLog
Download the automation jobs here, and then refer to the Word document inside.
Fonte: Cool DBA Automation Jobs