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.
Auf dieser Seite können Sie das Online-Video SQL Server Agent mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer PCTeachME 02 August 2010 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 17,805 Mal angesehen und es wurde von 34 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
