Background Job Error Event Class
The Background Job Error event class occurs when a background job has terminated abnormally. This condition might require the attention of a system administrator.
Data column name
ID of the database specified by job. Determine the value for a database by using the DB_ID function.
Name of the database in which the user statement is running.
Error number of the last attempt (EventSubClass 1 only).
Type of event = 193.
The sequence of a given event within the request.
Type of event subclass.
1 = Background job giving up after failure.
2 = Background job dropped - queue is full.
3 = Background job returned an error.
ID for the index on the object affected by the event. To determine the index ID for an object, use the indid column of the sysindexes system table.
Number of tries attempted by the job (EventSubClass 1 only).
Job sequence number.
System-assigned ID of the object.
Login name of the user that originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both SQL Server and Microsoft Windows logins.
Severity level of the error on the last attempt (EventSubClass 1 only).
Time at which the job was created.
State of the error on the last attempt (EventSubClass 1 only).
Text description of the event subclass value.
Type of job.