SQL Server Agent Service

The SQL Server Agent service is used by the SQL server to execute scheduled tasks, for example, backing up the SQL Server database and other maintenance tasks. By default, this service is not enabled when you install the SQL server. The SQL Server Agent service needs to be enabled on the SQL Server.

Enabling SQL Server Agent Service

To enable this service, use the SQL Server Configuration Manager tool. Follow these instructions to start this service.

1. To start this service on your SQL server, open the SQL Server Configuration Manager.
2. Right-click on SQL Server Agent service, and select Properties.
3. On the Properties dialog, on the Log On page, select an account in the Built-in account list.
4. On the Service page, select Start Mode, and click Automatic. Click OK to close the properties dialog.
5. In the SQL Server Configuration Manager, right-click on SQL Server Agent service, and click Start.
   The SQL Server Agent service is ready to use.

The following schedulers are created, and the schedulers are run by the SQL Server Agent service.

• ININ_ANALYTICS_COMPUTE_INTERACTION_DURATION

• ININ_ANALYTICS_CHECK_AND_PURGE