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.
In questa pagina del sito puoi guardare il video online SQL Server Agent della durata di ore minuti seconda in buona qualità , che l'utente ha caricato PCTeachME 02 agosto 2010, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 17,805 volte e gli è piaciuto 34 spettatori. Buona visione!
