Does Hangfire clear down old job data?

jamesatgreymetis · August 9, 2016, 3:55pm

I assume that Hangfire clears down these tables once a job has been Succeeded or jobs that have been Deleted?
HangFire.Job
HangFire.JobParameter
HangFire.State

If so what are the conditions that trigger it? I have been playing with Hangfire and have a lot of completed jobs in the DB which have not been deleted. I have searched the source and not been able to answer my question.

hometoast · August 12, 2016, 1:58pm

SqlServerJobStorage has its own ExpirationManager that it runs each hour.

jamesatgreymetis · August 12, 2016, 2:25pm

@hometoast perfect thanks, that’s what I was looking for

Link added for brevity:

github.com

HangfireIO/Hangfire/blob/master/src/Hangfire.SqlServer/SqlServerStorageOptions.cs#L38


private TimeSpan _queuePollInterval;
private string _schemaName;
private TimeSpan? _slidingInvisibilityTimeout;


public SqlServerStorageOptions()
{
    TransactionIsolationLevel = null;
    QueuePollInterval = TimeSpan.FromSeconds(15);
    SlidingInvisibilityTimeout = null;
#pragma warning disable 618
    InvisibilityTimeout = TimeSpan.FromMinutes(30);
#pragma warning restore 618
    JobExpirationCheckInterval = TimeSpan.FromMinutes(30);
    CountersAggregateInterval = TimeSpan.FromMinutes(5);
    PrepareSchemaIfNecessary = true;
    DashboardJobListLimit = 10000;
    _schemaName = Constants.DefaultSchema;
    TransactionTimeout = TimeSpan.FromMinutes(1);
}


public IsolationLevel? TransactionIsolationLevel { get; set; }

Topic		Replies	Views
Purge option for the db tables question sql-server	2	3781	August 4, 2015
How often are successful jobs physically deleted in the storage? question sql-server	3	5879	April 16, 2020
SQL Server Maintenance question sql-server	5	3501	February 16, 2015
Hangfire Failed Job Cleanup - SQL Server Storage question recurring , sql-server	1	2246	December 29, 2021
Poor performance on Job table (high cpu) question sql-server	0	340	April 26, 2024

Does Hangfire clear down old job data?

Related topics