Administration overview
What is it?
This section covers day-to-day administration of the SQL Agent. Use these pages to configure how the service runs, edit the SQLAgent.ini configuration file, start and stop the agent, and set up scripts that run when the agent starts or stops.
Pick the right page
| If you want to... | Go to |
|---|---|
| Choose the account the service runs as | Service configuration |
| Look up or change a setting in SQLAgent.ini | Configuration file |
| Start or stop the agent service | Manage the agent |
| Map network drives the agent needs | InitializationScript and TerminationScript |
In this section
- Service configuration — Configuration options for the SQL Agent service logon, including running as the Local System Account or as a Windows Domain User.
- Configuration file — Reference for the SQLAgent.ini configuration file, including general settings, TCP/IP parameters, debug options, and JORS settings.
- Manage the agent — Procedures for starting and stopping the SQL Agent service from the Windows Service Control Manager.
- InitializationScript and TerminationScript — How to use the InitializationScript and TerminationScript to map and unmap network resources.