posts - 4238, comments - 3946, trackbacks - 370

My Links

News



Subscribe Subscribe

image image image





This is my personal weblog. 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 employer.

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.

Powered by:
Powered By Subtext Powered By ASP.NET