Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions Links


SQL Server DBA Jobs

SQL Server DBA Top 10 automation tasks

20 June,2011 by Tom Collins

SQL Server Automation is one of the best ways for a DBA to achieve more in less time. If a task is repeatable – then why run it manually?

A word of warning!  There are automated jobs out in the SQL Server world that are causing more damage then help. I have seen plenty of Daily Shrink Database Jobs – that have done nothing but cause problems.

SQL Server Agent is a great framework for scheduling and managing jobs- but there are other schedulers . In larger environments I’ve used AutoSys  and  cron jobs (for DB2 management)  for scheduling. I also use Powershell – which lends itself to SQL Server 2005 , SQL Server 2008 , and also other aspects of the stack , such as Windows

Which ever method used , reporting is key to managing the jobs – is it a success or not?

I try and automate:


Index maintenance


Daily Health Checks

Disk Space

Exception based checked

Check keywords in SQL Server Logs such as “Error” - Read SQL Server - Powershell and SQL Error Logs

Powershell SQL Server Security Audit

SQL Server BackUp Review with Powershell

Failed SQL Server Agent Jobs -Read SQL Server - Powershell - List Failed SQL Server Jobs

 You can display some great value as a DBA by automating . The automation mentality allows you to scale very well. When organising automation jobs – consider the consequences for security. Be careful to not allow to many privileges.

Read More

Window Perfmon scripting, SQL Server perfmon and how to perfmon

SQL Server - Top 10 DBA mistakes

Author: Tom Collins (


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL Server DBA Top 10 automation tasks | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer