MS SQL Basics Tutorial: Agent services-Configuring SQL Server Agent

The SQL Server Agent is a task planner and an alert manager that, in real-world applications and environments, define cyclical activities as a task and run it automatically with the help of SQL Server Agent; If you are a system administrator, you can take advantage of SQL The Server Agent notifies you of a number of warning messages to locate problems to improve administrative efficiency. The SQL Server Agent consists mainly of the following components: Job, alert, operation.

Primarily perform the following steps to configure 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 the SQL Server Agent.

(2) Right-click the SQL Server Agent icon and select the Properties option in the pop-up menu. Open the SQL Server Agent Properties dialog box, and select the General tab page. As shown in Figure 17-1. The meanings of each of these options are:

System account: Defines which system accounts the SQL Server Agent runs under, which is a member of the sysadmin role; This account: defines which NT account the SQL Server Agent runs under, which must be a running The sysadmin role on the SQL Server Agent server, select this option and must provide a password at password. This option is often selected in the following situations:

Forwarding the event to the application log of other NT computers;

How to create a job that uses resources on multiple computers;

Notifies operator messages by e-mail or pager. Mail profile A valid message configuration file that saves the configuration information that is working for the mail system configured by SQL ServerAgent to run account with SQL Mail; Save copies of the sent messages in the Sen T Items folder: Specifies the file directory where messages are sent; file name: Specifies the SQL Server Agent log file name, the default name is c:mssql7logsqlagent.out Error message pop-up Recip ient Specifies the recipient name of the receiving network pop-up error message that the SQL Server Agent writes to its error log. (3) Select the Advanced tab page, as shown in Figure 17-2.

Auto Restart SQL Server if it stops unexpectedly: indicates that if SQL Server unexpectedly stops running, it will automatically restart; auto restart SQL Server Agent if it stop S unexpectedly: Indicates that if the SQL Server agent stops unexpectedly, it will be restarted automatically; Forward events to a different server: forwarding an event to another server. Select the receiving server in the Drop-down list next to the server; unhandled events: Forwarding messages that are not handled on the local server; all represents all events; If error has severity of or above: means only if the error level is greater than or is equal to the given value, the event is forwarded to the selected server; Idle CPU (s) Condition: Defines the CPU's null-closed state of the property value, that is, the CPU average utilization is lower than the given time value and the state lasts longer than the time, the CPU is considered to be in an empty state (4) Select the Alert System tab, as shown in Figure 17-3, address formatting for page e-mails: This area is used to set the message properties and add the error message to the paging message; Fail-Safe Operator: indicates failure ann A full operator that, if the message cannot reach the specified operator for an indeterminate reason, the SQL Server Agent passes the message to the failed-safe operator;

(5) Select the Job System tab, as shown in Figure 17-4;

Job History log: This area specifies the size of the log and the maximum number of rows per piece of work to avoid filling the msdb database; job execution: This area is used to set the maximum wait time for the SQL Server Agent before the job execution ends. If the job has not been executed for this time, the SQL Server Agent closes; non-sysadmin job step proxy account: This area is used to set up execution CmdExec and ActiveScripting

Restrictions on the job. (6) Select the Connection tab page, as shown in Figure 17-5.

SQL Server Connection: This zone defines the authentication mode to use when connecting SQL Server agents to SQL Server; SQL Server alias definition: alias for local SQL Server server. Note: A reboot is required after the SQL Server agent is configured for the configuration to take effect.

See the full set of "MS SQL Basics Tutorials"