SQL Server Agent
SQL Server Agent helps to perform various administrative tasks such as responding to predefined events, assisting in the automation of routine tasks, and processing alerts.
Steps to change the start-up type of SQL Server Agent.
SQL Server Configuration manager will help you to change the start-up type of SQL Server Agent to automatic.To do this, you have to change the properties of sql server agent service using SQL Server Configuration manager.
- Open the SQL Server Configuration
2. Select SQL Server services
3. Right click SQL Server Agent and click on properties
Click on service tab -> Select the Start mode as Automatic from drop down list ->Click on OK
Sql server Agent is made up of four basic components, which are used to define tasks, events, and define the users who will respond to events and alerts.