Class VacuumJob

Cleans out query tables in case of un-finalised frozen queries.

public class VacuumJob : ScheduledJobBase, IHostedService, IDisposable

Inheritance: object

BackgroundService

JobBase

ScheduledJobBase

VacuumJob

Inherited Members: ScheduledJobBase.Schedule

ScheduledJobBase.ExecuteAsync(CancellationToken)

ScheduledJobBase.Reschedule(Schedule)

ScheduledJobBase.Dispose()

JobBase.Logger

JobBase.Name

JobBase.IsJobRunRecordingEnabled

JobBase.JobRunProgressUpdateInterval

JobBase.RunningSince

JobBase.RunningUntil

JobBase.RunStatus

JobBase.CancelRun()

JobBase.CanExecute

JobBase.ExecuteOnceAsync(Identity, IPrincipal, CancellationToken)

JobBase.ExecuteOnceAsync(Identity, CancellationToken)

JobBase.ExecuteOnceAsync(IPrincipal, CancellationToken)

JobBase.ExecuteOnceAsync(CancellationToken)

JobBase.ExecuteOnceAsync(IProgress<Status>, IPrincipal, CancellationToken)

JobBase.ExecuteOnceAsync(IProgress<Status>, CancellationToken)

BackgroundService.StartAsync(CancellationToken)

BackgroundService.StopAsync(CancellationToken)

BackgroundService.ExecuteTask

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

This is an in-app version of the same work done by SQL Agent job The.SQL.DeleteQueryTables.

public VacuumJob(JobParameters<VacuumJob> parameters, IOptions<VacuumOptions> options, IDatabase database, IDMLDialect dml)

Creates a debug view of the data on which the job is currently operating.

protected override string DescribeJobParameters()

Implements the actual job logic.

protected override Task ExecuteJobAsync(IServices services, IPrincipal principal, IProgress<Status> progress, CancellationToken cancellationToken)