posts - 4237, comments - 3946, trackbacks - 370

Disclaimer

This was my personal weblog originally hosted by UgiDotNet, written mostly in Italian.

This blog is now part of my new site:
These postings are provided 'AS IS' with no warranties, and confer no rights. The views expressed on this weblog are mine alone and do not necessarily reflect the views of my employers.

Licenza Creative Commons

Tag Cloud

Archives

Post Categories

Per il DBA che c'è in me...

 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

Print | posted on martedì 19 giugno 2007 10:26 |

Comments have been closed on this topic.