Recently in the study of SQL, the SQL Agent and jobs have a certain understanding now come out and share with you, there is not the right place also please advise:
Homework is an automated thing, I give a simple example a book management system, when borrowing more than the deadline for users to fine operation, which is the use of homework can be easily handled. Just write the action you want to the job . and edit the frequency you want to operate in your homework. This will be done in the background to your database at a certain time ( you set the time ) to do the corresponding action.
The proxy is generated by the fact that the database itself does not have direct access to the operating system ( such as deleting the files we created on our computer ), and the agent ( associated with the corresponding credentials ) is used to handle the above mentioned actions.
For how they are created: there is a link that can be used
Http://www.cnblogs.com/stswordman/archive/2008/10/06/1302684.html
You'll get a deeper understanding of what's going on here.
A simple understanding of SQL agents and jobs: