SOLVED

is there a view i can use if my sql agent job history doesnt go back far enough

Copper Contributor

hi we know we gad a sql agent job go down but our view history doesnt go back far enough.  is there a view i can use as an alternative that might tell me about the error, date etc.

1 Reply
best response confirmed by db042190_foradf (Copper Contributor)
Solution

@db042190_foradf , of cause there is

dbo.sysjobhistory (Transact-SQL) - SQL Server | Microsoft Learn

 

But the job history is limited by row count, size an retention period.

If the UI don't show a longer history, then you also don't find it in the history table.

You have to increase the job history sttings.

1 best response

Accepted Solutions
best response confirmed by db042190_foradf (Copper Contributor)
Solution

@db042190_foradf , of cause there is

dbo.sysjobhistory (Transact-SQL) - SQL Server | Microsoft Learn

 

But the job history is limited by row count, size an retention period.

If the UI don't show a longer history, then you also don't find it in the history table.

You have to increase the job history sttings.

View solution in original post