SQL Server Agent Properties (General Tab)
Use this tab to view or specify the following options.
Options
System account
Run SQL Server Agent service under the system account.
This account
Specify the Microsoft® Windows NT® 4.0 or Windows® 2000 account under which the SQL Server Agent service runs.
Password
Specify the Windows NT 4.0 or Windows 2000 account password.
Mail profile
Specify a valid MAPI profile name that has been configured and tested for the SQL Server Agent service startup account.
Test
Start and stop a MAPI session (on the server) using the specified profile.
Save copies of the sent messages in the Sent Items folder
Specify that copies of all sent messages be saved in the Sent Items folder of Microsoft Outlook®, Microsoft Exchange client, or applicable MAPI-1 e-mail client.
File name
Specify the file name for the SQL Server Agent log. The default is C:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT. Click the browse (...) button to search for the error log directory.
View
View the SQL Server Agent error log.
Include execution trace messages
Include additional execution trace messages in the error log. This option should only be selected during specific SQL Server Agent problem investigations.
Write OEM File
Enable the Sqlagent.out file (error log file) to be written as a non-Unicode file. This saves disk space, especially when the Include execution trace messages check box is selected.
Net send recipient
Specify the name of a recipient to receive network pop-up notification of errors that SQL Server Agent writes to its error log.
See Also
How to change SQL Server services login account information (Enterprise Manager)