SQL Server Agent

After you have your database the way you want it, the next thing on your list of priorities should be maintenance. You can perform most things manually, but what if you wanted the server to do it? Well, this is where the SQL Server Agent comes in.

The SQL Server Agent is a SQL service that (if configured) is an always on service which runs specific commands at predetermined points in the day. The most classic example is backups, you will generally want to backup the system last thing at night. To do this you would create a “job”. Sounds simple? …well it is. However, there are other things to consider like what happens if it fails? Do you want it to try agian? Do you want it to notify you?

All these things are possible with the SQL server agent. This brief video will explain the basics of the agent but will take a while to master. A subsequent video will be released to deal specifically with maintenance plans (such as database backups etc…). SO sit back and watch this quick video about the basics which will get covered in more depth on subsequent tutorials.