SQLiteDelegate MembersQuartz.NET API Documentation

The SQLiteDelegate type exposes the following members.

Constructors

  NameDescription
Public methodSQLiteDelegate(ILog, String, String, IDbProvider)
Initializes a new instance of the SQLiteDelegate class.
Public methodSQLiteDelegate(ILog, String, String, IDbProvider, Boolean)
Initializes a new instance of the SQLiteDelegate class.
Top
Methods

  NameDescription
Protected methodAddCommandParameter(IDbCommand, Int32, String, Object) (Inherited from StdAdoDelegate.)
Protected methodAddCommandParameter(IDbCommand, Int32, String, Object, Enum) (Inherited from StdAdoDelegate.)
Public methodCalendarExists
Check whether or not a calendar exists.
(Inherited from StdAdoDelegate.)
Public methodCalendarIsReferenced
Check whether or not a calendar is referenced by any triggers.
(Inherited from StdAdoDelegate.)
Protected methodConvertFromProperty
Convert the JobDataMap into a list of properties.
(Inherited from StdAdoDelegate.)
Protected methodConvertToProperty
Convert the JobDataMap into a list of properties.
(Inherited from StdAdoDelegate.)
Public methodCountMisfiredTriggersInStates
Get the number of triggers in the given states that have misfired - according to the given timestamp.
(Inherited from StdAdoDelegate.)
Public methodDeleteAllPausedTriggerGroups
Deletes all paused trigger groups.
(Inherited from StdAdoDelegate.)
Public methodDeleteBlobTrigger
Delete the cron trigger data for a trigger.
(Inherited from StdAdoDelegate.)
Public methodDeleteCalendar
Delete a calendar.
(Inherited from StdAdoDelegate.)
Public methodDeleteCronTrigger
Delete the cron trigger data for a trigger.
(Inherited from StdAdoDelegate.)
Public methodDeleteFiredTrigger
Delete a fired trigger.
(Inherited from StdAdoDelegate.)
Public methodDeleteFiredTriggers(ConnectionAndTransactionHolder)
Delete all fired triggers.
(Inherited from StdAdoDelegate.)
Public methodDeleteFiredTriggers(ConnectionAndTransactionHolder, String)
Delete all fired triggers of the given instance.
(Inherited from StdAdoDelegate.)
Public methodDeleteJobDetail
Delete the job detail record for the given job.
(Inherited from StdAdoDelegate.)
Public methodDeleteJobListeners
Delete all job listeners for the given job.
(Inherited from StdAdoDelegate.)
Public methodDeletePausedTriggerGroup
Deletes the paused trigger group.
(Inherited from StdAdoDelegate.)
Public methodDeleteSchedulerState
Deletes the state of the scheduler.
(Inherited from StdAdoDelegate.)
Public methodDeleteSimpleTrigger
Delete the simple trigger data for a trigger.
(Inherited from StdAdoDelegate.)
Public methodDeleteTrigger
Delete the base trigger data for a trigger.
(Inherited from StdAdoDelegate.)
Public methodDeleteTriggerListeners
Delete all of the listeners associated with a given trigger.
(Inherited from StdAdoDelegate.)
Public methodDeleteVolatileFiredTriggers
Delete all volatile fired triggers.
(Inherited from StdAdoDelegate.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.)
Protected methodGetBoolean (Inherited from StdAdoDelegate.)
Protected methodGetDbBooleanValue
Gets the db presentation for boolean value. Subclasses can overwrite this behaviour.
(Inherited from StdAdoDelegate.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Protected methodGetJobDetailFromBlob
This method should be overridden by any delegate subclasses that need special handling for BLOBs for job details.
(Inherited from StdAdoDelegate.)
Protected methodGetKeyOfNonSerializableValue (Inherited from StdAdoDelegate.)
Protected methodGetObjectFromBlob
This method should be overridden by any delegate subclasses that need special handling for BLOBs. The default implementation uses standard ADO.NET operations.
(Inherited from StdAdoDelegate.)
Protected methodGetSelectNextTriggerToAcquireSql
Gets the select next trigger to acquire SQL clause. SQLite version with LIMIT support.
(Overrides StdAdoDelegate GetSelectNextTriggerToAcquireSql .)
Protected methodGetStorableJobTypeName (Inherited from StdAdoDelegate.)
Protected methodGetString (Inherited from StdAdoDelegate.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodInsertBlobTrigger
Insert the blob trigger data.
(Inherited from StdAdoDelegate.)
Public methodInsertCalendar
Insert a new calendar.
(Inherited from StdAdoDelegate.)
Public methodInsertCronTrigger
Insert the cron trigger data.
(Inherited from StdAdoDelegate.)
Public methodInsertFiredTrigger
Insert a fired trigger.
(Inherited from StdAdoDelegate.)
Public methodInsertJobDetail
Insert the job detail record.
(Inherited from StdAdoDelegate.)
Public methodInsertJobListener
Associate a listener with a job.
(Inherited from StdAdoDelegate.)
Public methodInsertPausedTriggerGroup
Inserts the paused trigger group.
(Inherited from StdAdoDelegate.)
Public methodInsertSchedulerState
Inserts the state of the scheduler.
(Inherited from StdAdoDelegate.)
Public methodInsertSimpleTrigger
Insert the simple trigger data.
(Inherited from StdAdoDelegate.)
Public methodInsertTrigger
Insert the base trigger data.
(Inherited from StdAdoDelegate.)
Public methodInsertTriggerListener
Associate a listener with the given trigger.
(Inherited from StdAdoDelegate.)
Public methodIsExistingTriggerGroup
Determines whether given trigger group already exists.
(Inherited from StdAdoDelegate.)
Public methodIsJobStateful
Check whether or not the given job is stateful.
(Inherited from StdAdoDelegate.)
Public methodIsTriggerGroupPaused
Determines whether the specified trigger group is paused.
(Inherited from StdAdoDelegate.)
Public methodJobExists
Check whether or not the given job exists.
(Inherited from StdAdoDelegate.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodPrepareCommand (Inherited from StdAdoDelegate.)
Protected methodReadBytesFromBlob (Inherited from StdAdoDelegate.)
Protected methodReplaceTablePrefix
Replace the table prefix in a query by replacing any occurrences of "{0}" with the table prefix.
(Inherited from StdAdoDelegate.)
Public methodSelectCalendar
Select a calendar.
(Inherited from StdAdoDelegate.)
Public methodSelectCalendars
Select all of the stored calendars.
(Inherited from StdAdoDelegate.)
Public methodSelectFiredTriggerInstanceNames
Select the distinct instance names of all fired-trigger records.
(Inherited from StdAdoDelegate.)
Public methodSelectFiredTriggerRecords
Select the states of all fired-trigger records for a given trigger, or trigger group if trigger name is  .
(Inherited from StdAdoDelegate.)
Public methodSelectFiredTriggerRecordsByJob
Select the states of all fired-trigger records for a given job, or job group if job name is  .
(Inherited from StdAdoDelegate.)
Public methodSelectInstancesFiredTriggerRecords
Select the states of all fired-trigger records for a given scheduler instance.
(Inherited from StdAdoDelegate.)
Public methodSelectJobDetail
Select the JobDetail object for a given job name / group name.
(Inherited from StdAdoDelegate.)
Public methodSelectJobExecutionCount
Selects the job execution count.
(Inherited from StdAdoDelegate.)
Public methodSelectJobForTrigger
Select the job to which the trigger is associated.
(Inherited from StdAdoDelegate.)
Public methodSelectJobGroups
Select all of the job group names that are stored.
(Inherited from StdAdoDelegate.)
Public methodSelectJobListeners
Get all of the listeners for a given job.
(Inherited from StdAdoDelegate.)
Public methodSelectJobsInGroup
Select all of the jobs contained in a given group.
(Inherited from StdAdoDelegate.)
Public methodSelectMisfiredTriggers
Get the names of all of the triggers that have misfired.
(Inherited from StdAdoDelegate.)
Public methodSelectMisfiredTriggersInGroupInState
Get the names of all of the triggers in the given group and state that have misfired.
(Inherited from StdAdoDelegate.)
Public methodSelectMisfiredTriggersInState
Get the names of all of the triggers in the given state that have misfired - according to the given timestamp.
(Inherited from StdAdoDelegate.)
Public methodSelectMisfiredTriggersInStates
Get the names of all of the triggers in the given states that have misfired - according to the given timestamp. No more than count will be returned.
(Inherited from StdAdoDelegate.)
Public methodSelectNumCalendars
Select the total number of calendars stored.
(Inherited from StdAdoDelegate.)
Public methodSelectNumJobs
Select the total number of jobs stored.
(Inherited from StdAdoDelegate.)
Public methodSelectNumTriggers
Select the total number of triggers stored.
(Inherited from StdAdoDelegate.)
Public methodSelectNumTriggersForJob
Select the number of triggers associated with a given job.
(Inherited from StdAdoDelegate.)
Public methodSelectPausedTriggerGroups
Selects the paused trigger groups.
(Inherited from StdAdoDelegate.)
Public methodSelectSchedulerStateRecords
A List of all current SchedulerStateRecords.

If instanceId is not null, then only the record for the identified instance will be returned.

(Inherited from StdAdoDelegate.)
Public methodSelectStatefulJobsOfTriggerGroup
Selects the stateful jobs of trigger group.
(Inherited from StdAdoDelegate.)
Public methodSelectTrigger
Select a trigger.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerForFireTime
Select the trigger that will be fired at the given fire time.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerGroups
Select all of the trigger group names that are stored.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerJobDataMap
Select a trigger's JobDataMap.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerListeners
Select the listeners associated with a given trigger.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerNamesForJob
Get the names of all of the triggers associated with the given job.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggersForCalendar
Select the triggers for a calendar
(Inherited from StdAdoDelegate.)
Public methodSelectTriggersForJob
Select the triggers for a job
(Inherited from StdAdoDelegate.)
Public methodSelectTriggersForRecoveringJobs
Select all of the triggers for jobs that are requesting recovery. The returned trigger objects will have unique "recoverXXX" trigger names and will be in the DefaultRecoveryGroup trigger group.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggersInGroup
Select all of the triggers contained in a given group.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggersInState
Select all of the triggers in a given state.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerState
Select a trigger's state value.
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerStatus
Select a trigger status (state and next fire time).
(Inherited from StdAdoDelegate.)
Public methodSelectTriggerToAcquire
Select the next trigger which will fire to fire between the two given timestamps in ascending order of fire time, and then descending by priority.
(Inherited from StdAdoDelegate.)
Public methodSelectVolatileJobs
Get the names of all of the jobs that are volatile.
(Inherited from StdAdoDelegate.)
Public methodSelectVolatileTriggers
Get the names of all of the triggers that are volatile.
(Inherited from StdAdoDelegate.)
Public methodSerializeJobData
Remove the transient data from and then create a serialized MemoryStream version of a JobDataMap and returns the underlying bytes.
(Inherited from StdAdoDelegate.)
Protected methodSerializeObject
Create a serialized version of an Object.
(Inherited from StdAdoDelegate.)
Public methodToString
Returns a String that represents the current Object.
(Inherited from Object.)
Public methodTriggerExists
Check whether or not a trigger exists.
(Inherited from StdAdoDelegate.)
Public methodUpdateBlobTrigger
Update the blob trigger data.
(Inherited from StdAdoDelegate.)
Public methodUpdateCalendar
Update a calendar.
(Inherited from StdAdoDelegate.)
Public methodUpdateCronTrigger
Update the cron trigger data.
(Inherited from StdAdoDelegate.)
Public methodUpdateJobData
Update the job data map for the given job.
(Inherited from StdAdoDelegate.)
Public methodUpdateJobDetail
Update the job detail record.
(Inherited from StdAdoDelegate.)
Public methodUpdateSchedulerState
Updates the state of the scheduler.
(Inherited from StdAdoDelegate.)
Public methodUpdateSimpleTrigger
Update the simple trigger data.
(Inherited from StdAdoDelegate.)
Public methodUpdateTrigger
Update the base trigger data.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerGroupStateFromOtherState
Update all of the triggers of the given group to the given new state, if they are in the given old state.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerGroupStateFromOtherStates
Update all triggers in the given group to the given new state, if they are in one of the given old states.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerState
Update the state for a given trigger.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerStateFromOtherState
Update the given trigger to the given new state, if it is in the given old state.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerStateFromOtherStates
Update the given trigger to the given new state, if it is one of the given old states.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerStateFromOtherStatesBeforeTime
Update the all triggers to the given new state, if they are in one of the given old states AND its next fire time is before the given time.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerStatesForJob
Update the states of all triggers associated with the given job.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerStatesForJobFromOtherState
Updates the state of the trigger states for job from other.
(Inherited from StdAdoDelegate.)
Public methodUpdateTriggerStatesFromOtherStates
Insert the job detail record.
(Inherited from StdAdoDelegate.)
Top
Fields

  NameDescription
Protected fieldadoUtil (Inherited from StdAdoDelegate.)
Protected fielddbProvider (Inherited from StdAdoDelegate.)
Protected fieldinstanceId (Inherited from StdAdoDelegate.)
Protected fieldlogger (Inherited from StdAdoDelegate.)
Protected fieldtablePrefix (Inherited from StdAdoDelegate.)
Protected fielduseProperties (Inherited from StdAdoDelegate.)
Top
Properties

  NameDescription
Protected propertyCanUseProperties (Inherited from StdAdoDelegate.)
Protected propertyTriggersToAcquireLimit
Gets the triggers to acquire limit.
(Inherited from StdAdoDelegate.)
Top
See Also