Roles of SQL Server Agent

The SQL Server Agent is a task scheduler and alarm manager. In actual applications and environments, you can define periodic activities as a task, with the help of the SQL Server Agent, you can use the SQL Server Agent to automatically run SQL Server. If you are a system administrator, you can use the SQL Server Agent to notify you of some warning information, to locate problems and improve management efficiency. The SQL Server Agent mainly includes the following components: Job, alarm, and operation.
Perform the following steps to configure the SQL Server Agent in SQL Server Enterprise Manager:

(1) start SQL Server Enterprise Manager, log on to the specified Server, open the Management folder, and start SQL Server Agent.
(2) Right-click the SQL Server Agent icon and select Properties from the pop-up menu. Open the SQL Server Agent Properties dialog box and select the General tab. 17-1. The meanings of each option are as follows:
System account: The System account under which the SQL Server Agent runs. The System account is a member of the sysadmin role;
This account: defines which NT account the SQL Server Agent runs under. This account must be the sysadmin role on the SQL Server Agent Server. If This option is selected, the Password must be provided. Select this option in the following cases:
Transfers events to application logs of other NT computers;
How to Create a job that uses resources on multiple computers;
Notify the operator by email or paging.
The Mail Profile has a valid Mail configuration file name. This file stores the configuration information for the normal operation of the Mail system configured for the SQL ServerAgent running account through SQL Mail;
Save copies of the sent messages in the Sent Items folder: Specifies the directory where the sent messages are stored;
File name: Specifies the SQL Server Agent Log File name. The default name is C: \ Mssql7 \ Log \ Sqlagent. out;
Error message pop-up recipient specifies the name of the receiver that receives the pop-up Error message from the network. These Error messages are written to the Error log by the SQL Server Agent.
(3) Select the Advanced Tab
Auto restart SQL Server if it stops unexpectedly: indicates that if SQL Server stops running unexpectedly, it will be restarted automatically;
Auto restart SQL Server Agent if it stops unexpectedly: indicates that if the SQL Server Agent stops running unexpectedly, it will be restarted automatically;
Forward events to a different server: Forward the event to another server. Select the receiving Server from the drop-down list next to the Server;
Unhandled events: Forward events that are not processed on the local server; All indicates All events;
If error has severity of or above: indicates that the event is forwarded to the selected server only when the error level is greater than or equal to the given value;
Idle CPU (s) Condition: defines the attribute value of the CPU empty closed state, that is, the average CPU usage is lower than the given irregular value and the duration of the Status exceeds the specified time, the CPU is considered to be empty and closed.
4) Select the Alert System tab.
Address formatting for page e-mails: This area is used to set message attributes and add error messages to paging information;
Fail-safe operator: indicates a failed security operator. If the message cannot reach the specified operator due to unknown reasons, the SQL Server Agent sends the message to the failed security operator;
(5) Select the Job System tab.
Job history log: Specify the log size and the maximum number of lines for each Job in the region to avoid filling up the msdb database;
Job execution: This area is used to set the maximum waiting time for the SQL Server Agent before the Job execution ends. if the Job is not executed after this time, the SQL Server Agent is disabled;
Non-SysAdmin job step proxy account: this region is used to set the execution of CmdExec and ActiveScripting
Job restrictions.
(6) Select the Connection tab.
SQLServer Connection: This region defines the Authentication mode used to connect the SQL Server Agent to the SQL Server;
SQLServer alias: alias of the local SQL Server.
Note: After configuring the SQL Server Agent, you must restart it to make the configuration take effect.