SQL Server Maintenance

[odinserj]

Please see the following thread:

How to configure the retention time of job?

First of all, retention, or expiration time is setting up only for successful and deleted jobs. Other job states, including the failed state, don’t have any expiration time. That is why your failed jobs will be kept infinitely before you fix/retry or delete them manually. But if you really want to set up retention time for succeeded or deleted jobs, you can add the following job filter (they are like action filters in ASP.NET MVC): public class ProlongExpirationTimeAttribute : JobFilterAttribu…