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.
Background Job Error Event Class Data Columns
| Data column name | Data type | Description | Column ID | Filterable |
|---|---|---|---|---|
DatabaseID |
int |
ID of the database specified by job. Determine the value for a database by using the DB_ID function. |
3 |
Yes |
DatabaseName |
nvarchar |
Name of the database in which the user statement is running. |
35 |
Yes |
Error |
int |
Error number of the last attempt (EventSubClass 1 only). |
31 |
Yes |
EventClass |
int |
Type of event = 193. |
27 |
No |
EventSequence |
int |
The sequence of a given event within the request. |
51 |
No |
EventSubClass |
int |
Type of event subclass. 1 = Background job giving up after failure. 2 = Background job dropped - queue is full. 3 = Background job returned an error. |
21 |
Yes |
IndexID |
int |
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. |
24 |
Yes |
IntegerData |
int |
Number of tries attempted by the job (EventSubClass 1 only). |
25 |
Yes |
IntegerData2 |
int |
Job sequence number. |
55 |
Yes |
ObjectID |
int |
System-assigned ID of the object. |
22 |
Yes |
SessionLoginName |
nvarchar |
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. |
64 |
Yes |
Severity |
int |
Severity level of the error on the last attempt (EventSubClass 1 only). |
20 |
Yes |
StartTime |
datetime |
Time at which the job was created. |
14 |
Yes |
State |
int |
State of the error on the last attempt (EventSubClass 1 only). |
30 |
Yes |
TextData |
ntext |
Text description of the event subclass value. |
1 |
Yes |
Type |
int |
Type of job. |
57 |
Yes |
See Also
Reference
Other Resources
Monitoring Events
sp_trace_setevent (Transact-SQL)