SQL Server Maintenance

[cbetz]

We’d like to use Hangfire (and get support) but our DBA has raised some questions that I would like to get answered before we make the final call. Specifically he has asked:

Do you have any documentation on how the database should be maintained? Will it continue to grow over time or is there some sort of purge functionality?

Thanks in advance!

[odinserj]

Hello, @cbetz! Your DBA may sleep peacefully as Hangfire has expiration logic for every entity. For example, jobs are being deleted after 24h (configurable) after completion with all related data.

[cbetz]

Thanks for the quick reply @odinserj!

[mitchell_amasia]

@odinserj, how/where can I configure this??

[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…

[mitchell_amasia]

Alright, Thank you!