Executing SQL Server Agent Jobs
Ah, good old SQL Server Agent. What would we do without you? Well, that’s easy; nothing. Not in this book, anyway. The purpose of SQL Server Agent is to execute scheduled administrative tasks, so without it, we couldn’t do anything automatically and we would have to do all of this manually. Now, don’t get me wrong; all of this can be done in T-SQL… but why would you want to do that, when you can have trusty SQL Server Agent do it’s one and only job?