Whether or not to obtain locks when inserting new jobs/triggers.
Namespace: Quartz.Impl.AdoJobStore
Assembly: Quartz (in Quartz.dll) Version: 3.0.0
Syntax
C#
public virtual bool LockOnInsert { get; set; }
Property Value
Type: BooleanRemarks
Defaults to , which is safest - some db's (such as MS SQLServer) seem to require this to avoid deadlocks under high load, while others seem to do fine without. Settings this to false means isolation guarantees between job scheduling and trigger acquisition are entirely enforced by the database. Depending on the database and it's configuration this may cause unusual scheduling behaviors.
Setting this property to will provide a significant performance increase during the addition of new jobs and triggers.
See Also