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.
En esta página del sitio puede ver el video en línea SQL Server Agent de Duración hora minuto segunda en buena calidad , que subió el usuario PCTeachME 02 agosto 2010, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 17,805 veces y le gustó 34 a los espectadores. Disfruta viendo!
