Content deleted Content added
use proper stub template instead of placing directly in category |
No edit summary |
||
Line 1:
{{unreferenced|date=June 2011}}
'''SQL Server Agent''' is a process which executes [[SQL]] jobs and handles other automated tasks. It can be configured to run automatically when the [[Booting|system boots]] or it can be started manually. It is a component of [[Microsoft SQL Server]].
SQL Agent Configuration
Behind the scenes, SQL Agent Job definitions are specified in the msdb database. You might remember the msdb database from a previous lesson. It is a system database that is created when you first install SQL Server.
You don't really need to know that in order to use the SQL Agent Service though. You can configure SQL Server Agent jobs, alerts and operators via Enterprise Manager. Applications that use SQL-DMO or Transact-SQL with a standard database API can also do this, but for now, we'll stick with Enterprise Manager.
[[Category:Database management systems]]
| |||