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