Class AdoConstants

Namespace

Quartz.Impl.AdoJobStore

Assembly

Quartz.dll

The table, column and state names of the standard Quartz database schema, for IDriverDelegate and ITriggerPersistenceDelegate implementations that read and write it.

public static class AdoConstants

Inheritance

object

AdoConstants

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

These used to be inherited: a delegate declared : AdoConstants and referred to the names unqualified. Inheritance is not how a constant container is consumed — it burns the single base class of every type that wants to name a column — so this is a static class now, named explicitly at the use site.

Fields

AllGroupsPaused

The group name a store records in the paused-groups table to mean that every group is paused, including the ones added next.

public const string AllGroupsPaused = "_$_ALL_GROUPS_PAUSED_$_"

Field Value

string

ColumnBlob

The BLOB_DATA column of TableBlobTriggers.

public const string ColumnBlob = "BLOB_DATA"

Field Value

string

ColumnCalendar

The CALENDAR column of TableCalendars.

public const string ColumnCalendar = "CALENDAR"

Field Value

string

ColumnCalendarName

The CALENDAR_NAME column of TableCalendars.

public const string ColumnCalendarName = "CALENDAR_NAME"

Field Value

string

ColumnCheckinInterval

The CHECKIN_INTERVAL column of TableSchedulerState.

public const string ColumnCheckinInterval = "CHECKIN_INTERVAL"

Field Value

string

ColumnCronExpression

The CRON_EXPRESSION column of TableCronTriggers.

public const string ColumnCronExpression = "CRON_EXPRESSION"

Field Value

string

ColumnDescription

The DESCRIPTION column of TableJobDetails.

public const string ColumnDescription = "DESCRIPTION"

Field Value

string

ColumnEndTime

The END_TIME column of TableTriggers.

public const string ColumnEndTime = "END_TIME"

Field Value

string

ColumnEntryId

The ENTRY_ID column of TableFiredTriggers.

public const string ColumnEntryId = "ENTRY_ID"

Field Value

string

ColumnEntryState

The STATE column of TableFiredTriggers.

public const string ColumnEntryState = "STATE"

Field Value

string

ColumnExecutionGroup

The EXECUTION_GROUP column of TableTriggers.

public const string ColumnExecutionGroup = "EXECUTION_GROUP"

Field Value

string

ColumnFiredTime

The FIRED_TIME column of TableFiredTriggers.

public const string ColumnFiredTime = "FIRED_TIME"

Field Value

string

ColumnInstanceName

The INSTANCE_NAME column of TableFiredTriggers.

public const string ColumnInstanceName = "INSTANCE_NAME"

Field Value

string

ColumnIsDurable

The IS_DURABLE column of TableJobDetails.

public const string ColumnIsDurable = "IS_DURABLE"

Field Value

string

ColumnIsNonConcurrent

The IS_NONCONCURRENT column of TableJobDetails.

public const string ColumnIsNonConcurrent = "IS_NONCONCURRENT"

Field Value

string

ColumnIsUpdateData

The IS_UPDATE_DATA column of TableJobDetails.

public const string ColumnIsUpdateData = "IS_UPDATE_DATA"

Field Value

string

ColumnJobClass

The JOB_CLASS_NAME column of TableJobDetails.

public const string ColumnJobClass = "JOB_CLASS_NAME"

Field Value

string

ColumnJobDataMap

The JOB_DATA column of TableJobDetails.

public const string ColumnJobDataMap = "JOB_DATA"

Field Value

string

ColumnJobGroup

The JOB_GROUP column of TableJobDetails.

public const string ColumnJobGroup = "JOB_GROUP"

Field Value

string

ColumnJobName

The JOB_NAME column of TableJobDetails.

public const string ColumnJobName = "JOB_NAME"

Field Value

string

ColumnLastCheckinTime

The LAST_CHECKIN_TIME column of TableSchedulerState.

public const string ColumnLastCheckinTime = "LAST_CHECKIN_TIME"

Field Value

string

ColumnLockName

The LOCK_NAME column of TableLocks.

public const string ColumnLockName = "LOCK_NAME"

Field Value

string

ColumnMisfireInstruction

The MISFIRE_INSTR column of TableTriggers.

public const string ColumnMisfireInstruction = "MISFIRE_INSTR"

Field Value

string

ColumnMisfireOriginalFireTime

The MISFIRE_ORIG_FIRE_TIME column of TableTriggers.

public const string ColumnMisfireOriginalFireTime = "MISFIRE_ORIG_FIRE_TIME"

Field Value

string

ColumnNextFireTime

The NEXT_FIRE_TIME column of TableTriggers.

public const string ColumnNextFireTime = "NEXT_FIRE_TIME"

Field Value

string

ColumnPreferredNode

The PREFERRED_NODE column of TableTriggers.

public const string ColumnPreferredNode = "PREFERRED_NODE"

Field Value

string

ColumnPreferredNodeAuto

The PREFERRED_NODE_AUTO column of TableTriggers.

public const string ColumnPreferredNodeAuto = "PREFERRED_NODE_AUTO"

Field Value

string

ColumnPreviousFireTime

The PREV_FIRE_TIME column of TableTriggers.

public const string ColumnPreviousFireTime = "PREV_FIRE_TIME"

Field Value

string

ColumnPriority

The PRIORITY column of TableTriggers.

public const string ColumnPriority = "PRIORITY"

Field Value

string

ColumnRepeatCount

The REPEAT_COUNT column of TableSimpleTriggers.

public const string ColumnRepeatCount = "REPEAT_COUNT"

Field Value

string

ColumnRepeatInterval

The REPEAT_INTERVAL column of TableSimpleTriggers.

public const string ColumnRepeatInterval = "REPEAT_INTERVAL"

Field Value

string

ColumnRequestsRecovery

The REQUESTS_RECOVERY column of TableJobDetails.

public const string ColumnRequestsRecovery = "REQUESTS_RECOVERY"

Field Value

string

ColumnRetryAttempt

The RETRY_ATTEMPT column of TableTriggers.

public const string ColumnRetryAttempt = "RETRY_ATTEMPT"

Field Value

string

ColumnRetryPolicy

The RETRY_POLICY column of TableTriggers.

public const string ColumnRetryPolicy = "RETRY_POLICY"

Field Value

string

ColumnScheduledTime

The SCHED_TIME column of TableFiredTriggers.

public const string ColumnScheduledTime = "SCHED_TIME"

Field Value

string

ColumnSchedulerName

The SCHED_NAME column of TableJobDetails.

public const string ColumnSchedulerName = "SCHED_NAME"

Field Value

string

ColumnStartTime

The START_TIME column of TableTriggers.

public const string ColumnStartTime = "START_TIME"

Field Value

string

ColumnTimeZoneId

The TIME_ZONE_ID column of TableBlobTriggers.

public const string ColumnTimeZoneId = "TIME_ZONE_ID"

Field Value

string

ColumnTimesTriggered

The TIMES_TRIGGERED column of TableSimpleTriggers.

public const string ColumnTimesTriggered = "TIMES_TRIGGERED"

Field Value

string

ColumnTriggerGroup

The TRIGGER_GROUP column of TableTriggers.

public const string ColumnTriggerGroup = "TRIGGER_GROUP"

Field Value

string

ColumnTriggerName

The TRIGGER_NAME column of TableTriggers.

public const string ColumnTriggerName = "TRIGGER_NAME"

Field Value

string

ColumnTriggerState

The TRIGGER_STATE column of TableTriggers.

public const string ColumnTriggerState = "TRIGGER_STATE"

Field Value

string

ColumnTriggerType

The TRIGGER_TYPE column of TableTriggers.

public const string ColumnTriggerType = "TRIGGER_TYPE"

Field Value

string

DefaultTablePrefix

The table prefix a store uses when the configuration names none.

public const string DefaultTablePrefix = "QRTZ_"

Field Value

string

ParameterPageSkip

The name of the parameter carrying how many rows a page skips.

public const string ParameterPageSkip = "pageSkip"

Field Value

string

Remarks

ApplyPaging(string, bool) splices these two names into the statement and AddPagingParameters(DbCommand, int, int, bool) binds them, and a delegate that overrides one of those members has to spell the same names in the other — so they are a contract between two assemblies, not one delegate's private detail. They are here rather than only on the internal list Quartz's own statements use, because this class is where the names a delegate must agree with already live.

The value is the bare name; the statement carries it prefixed, as "@" + ParameterPageSkip.

ParameterPageTake

The name of the parameter carrying how many rows a page reads.

public const string ParameterPageTake = "pageTake"

Field Value

string

Remarks

The other half of the pair ParameterPageSkip describes. It is absent from the statement altogether when the caller asked for an unbounded page.

StateAcquired

The stored state of a trigger acquired by a node, which will fire it.

public const string StateAcquired = "ACQUIRED"

Field Value

string

StateBlocked

The stored state of a trigger held back because another firing of its non-concurrent job is running.

public const string StateBlocked = "BLOCKED"

Field Value

string

StateComplete

The stored state of a trigger finished and will not fire again.

public const string StateComplete = "COMPLETE"

Field Value

string

StateDeleted

The stored state of a trigger deleted, which is a transient marker rather than a resting state.

public const string StateDeleted = "DELETED"

Field Value

string

StateError

The stored state of a trigger in error, and will not fire until it is reset.

public const string StateError = "ERROR"

Field Value

string

StateExecuting

The stored state of a trigger firing now.

public const string StateExecuting = "EXECUTING"

Field Value

string

StatePaused

The stored state of a trigger paused.

public const string StatePaused = "PAUSED"

Field Value

string

StatePausedBlocked

The stored state of a trigger paused and blocked at once, so resuming it leaves it blocked.

public const string StatePausedBlocked = "PAUSED_BLOCKED"

Field Value

string

StateWaiting

The stored state of a trigger waiting for its next fire time.

public const string StateWaiting = "WAITING"

Field Value

string

TableBlobTriggers

The BLOB_TRIGGERS table, without the table prefix.

public const string TableBlobTriggers = "BLOB_TRIGGERS"

Field Value

string

TableCalendars

The CALENDARS table, without the table prefix.

public const string TableCalendars = "CALENDARS"

Field Value

string

TableCronTriggers

The CRON_TRIGGERS table, without the table prefix.

public const string TableCronTriggers = "CRON_TRIGGERS"

Field Value

string

TableFiredTriggers

The FIRED_TRIGGERS table, without the table prefix.

public const string TableFiredTriggers = "FIRED_TRIGGERS"

Field Value

string

TableJobDetails

The JOB_DETAILS table, without the table prefix.

public const string TableJobDetails = "JOB_DETAILS"

Field Value

string

TableLocks

The LOCKS table, without the table prefix.

public const string TableLocks = "LOCKS"

Field Value

string

TablePausedJobs

The PAUSED_JOB_GRPS table, without the table prefix.

public const string TablePausedJobs = "PAUSED_JOB_GRPS"

Field Value

string

TablePausedTriggers

The PAUSED_TRIGGER_GRPS table, without the table prefix.

public const string TablePausedTriggers = "PAUSED_TRIGGER_GRPS"

Field Value

string

TableSchedulerState

The SCHEDULER_STATE table, without the table prefix.

public const string TableSchedulerState = "SCHEDULER_STATE"

Field Value

string

TableSimplePropertiesTriggers

The SIMPROP_TRIGGERS table, without the table prefix.

public const string TableSimplePropertiesTriggers = "SIMPROP_TRIGGERS"

Field Value

string

TableSimpleTriggers

The SIMPLE_TRIGGERS table, without the table prefix.

public const string TableSimpleTriggers = "SIMPLE_TRIGGERS"

Field Value

string

TableTriggers

The TRIGGERS table, without the table prefix.

public const string TableTriggers = "TRIGGERS"

Field Value

string

TriggerTypeBlob

A general blob Trigger type.

public const string TriggerTypeBlob = "BLOB"

Field Value

string

TriggerTypeCalendarInterval

Calendar Interval Trigger type.

public const string TriggerTypeCalendarInterval = "CAL_INT"

Field Value

string

TriggerTypeCron

Cron Trigger type.

public const string TriggerTypeCron = "CRON"

Field Value

string

TriggerTypeDailyTimeInterval

Daily Time Interval Trigger type.

public const string TriggerTypeDailyTimeInterval = "DAILY_I"

Field Value

string

TriggerTypeRecurrence

Recurrence (RRULE) Trigger type.

public const string TriggerTypeRecurrence = "RECUR"

Field Value

string

TriggerTypeSimple

Simple Trigger type.

public const string TriggerTypeSimple = "SIMPLE"

Field Value

string