Forum Discussion
Solved
is there a view i can use if my sql agent job history doesnt go back far enough
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.
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.
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.
