Edit

SQL Server Agent Error Log

  • Article

Applies to: SQL Server Azure SQL Managed Instance

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

SQL Server Agent creates an error log that records warnings and errors by default. The following warnings and errors are displayed in the log:

  • Warning messages that provide information about potential problems, such as "Job <job_name> was deleted while it was running."

  • Error messages that usually require intervention by a system administrator, such as "Unable to start mail session." Error messages can be sent to a specific user or computer by net send.

SQL Server maintains up to nine SQL Server Agent error logs. Each archived log has an extension that indicates the relative age of the log. For example, an extension of .1 indicates the newest archived error log and an extension of .9 indicates the oldest archived error log.

By default, execution trace messages are not written to the SQL Server Agent error log, because they can fill it. When the error log is full, your ability to select and analyze more difficult errors is reduced. Because the log adds to the server's processing load, it is important to consider carefully what value you obtain by capturing execution trace messages to the error log. Generally, it is best to capture all messages only when you are debugging a specific problem.

When SQL Server Agent is stopped, you can modify the location of the SQL Server Agent error log. When the error log is empty, the log cannot be opened. You can cycle the SQL Server Agent log at any time without stopping SQL Server Agent using dbo.sp_cycle_agent_errorlog.

To view the SQL Server Agent error log

To rename a SQL Server Agent error log

To send SQL Server Agent error messages

To write execution trace messages to the SQL Server Agent error log