The StdAdoDelegate type exposes the following members.
Constructors
Name | Description | |
---|---|---|
StdAdoDelegate(ILog, String, String, IDbProvider) |
Create new StdAdoDelegate instance.
| |
StdAdoDelegate(ILog, String, String, IDbProvider, Boolean) |
Create new StdAdoDelegate instance.
|
Methods
Name | Description | |
---|---|---|
AddCommandParameter(IDbCommand, Int32, String, Object) | ||
AddCommandParameter(IDbCommand, Int32, String, Object, Enum) | ||
CalendarExists |
Check whether or not a calendar exists.
| |
CalendarIsReferenced |
Check whether or not a calendar is referenced by any triggers.
| |
ConvertFromProperty |
Convert the JobDataMap into a list of properties.
| |
ConvertToProperty |
Convert the JobDataMap into a list of properties.
| |
CountMisfiredTriggersInStates |
Get the number of triggers in the given states that have
misfired - according to the given timestamp.
| |
DeleteAllPausedTriggerGroups |
Deletes all paused trigger groups.
| |
DeleteBlobTrigger |
Delete the cron trigger data for a trigger.
| |
DeleteCalendar |
Delete a calendar.
| |
DeleteCronTrigger |
Delete the cron trigger data for a trigger.
| |
DeleteFiredTrigger |
Delete a fired trigger.
| |
DeleteFiredTriggers(ConnectionAndTransactionHolder) |
Delete all fired triggers.
| |
DeleteFiredTriggers(ConnectionAndTransactionHolder, String) |
Delete all fired triggers of the given instance.
| |
DeleteJobDetail |
Delete the job detail record for the given job.
| |
DeleteJobListeners |
Delete all job listeners for the given job.
| |
DeletePausedTriggerGroup |
Deletes the paused trigger group.
| |
DeleteSchedulerState |
Deletes the state of the scheduler.
| |
DeleteSimpleTrigger |
Delete the simple trigger data for a trigger.
| |
DeleteTrigger |
Delete the base trigger data for a trigger.
| |
DeleteTriggerListeners |
Delete all of the listeners associated with a given trigger.
| |
DeleteVolatileFiredTriggers |
Delete all volatile fired triggers.
| |
Equals | (Inherited from Object.) | |
Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.) | |
GetBoolean | ||
GetDbBooleanValue |
Gets the db presentation for boolean value. Subclasses can overwrite this behaviour.
| |
GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) | |
GetJobDetailFromBlob |
This method should be overridden by any delegate subclasses that need
special handling for BLOBs for job details.
| |
GetKeyOfNonSerializableValue | ||
GetObjectFromBlob |
This method should be overridden by any delegate subclasses that need
special handling for BLOBs. The default implementation uses standard
ADO.NET operations.
| |
GetSelectNextTriggerToAcquireSql |
Gets the select next trigger to acquire SQL clause.
This can be overriden for a more performant, result limiting
SQL. For Example SQL Server, MySQL and SQLite support limiting returned rows.
| |
GetStorableJobTypeName | ||
GetString | ||
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
InsertBlobTrigger |
Insert the blob trigger data.
| |
InsertCalendar |
Insert a new calendar.
| |
InsertCronTrigger |
Insert the cron trigger data.
| |
InsertFiredTrigger |
Insert a fired trigger.
| |
InsertJobDetail |
Insert the job detail record.
| |
InsertJobListener |
Associate a listener with a job.
| |
InsertPausedTriggerGroup |
Inserts the paused trigger group.
| |
InsertSchedulerState |
Inserts the state of the scheduler.
| |
InsertSimpleTrigger |
Insert the simple trigger data.
| |
InsertTrigger |
Insert the base trigger data.
| |
InsertTriggerListener |
Associate a listener with the given trigger.
| |
IsExistingTriggerGroup |
Determines whether given trigger group already exists.
| |
IsJobStateful |
Check whether or not the given job is stateful.
| |
IsTriggerGroupPaused |
Determines whether the specified trigger group is paused.
| |
JobExists |
Check whether or not the given job exists.
| |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
PrepareCommand | ||
ReadBytesFromBlob | ||
ReplaceTablePrefix |
Replace the table prefix in a query by replacing any occurrences of
"{0}" with the table prefix.
| |
SelectCalendar |
Select a calendar.
| |
SelectCalendars |
Select all of the stored calendars.
| |
SelectFiredTriggerInstanceNames |
Select the distinct instance names of all fired-trigger records.
| |
SelectFiredTriggerRecords |
Select the states of all fired-trigger records for a given trigger, or
trigger group if trigger name is .
| |
SelectFiredTriggerRecordsByJob |
Select the states of all fired-trigger records for a given job, or job
group if job name is .
| |
SelectInstancesFiredTriggerRecords |
Select the states of all fired-trigger records for a given scheduler
instance.
| |
SelectJobDetail |
Select the JobDetail object for a given job name / group name.
| |
SelectJobExecutionCount |
Selects the job execution count.
| |
SelectJobForTrigger |
Select the job to which the trigger is associated.
| |
SelectJobGroups |
Select all of the job group names that are stored.
| |
SelectJobListeners |
Get all of the listeners for a given job.
| |
SelectJobsInGroup |
Select all of the jobs contained in a given group.
| |
SelectMisfiredTriggers |
Get the names of all of the triggers that have misfired.
| |
SelectMisfiredTriggersInGroupInState |
Get the names of all of the triggers in the given group and state that
have misfired.
| |
SelectMisfiredTriggersInState |
Get the names of all of the triggers in the given state that have
misfired - according to the given timestamp.
| |
SelectMisfiredTriggersInStates |
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.
| |
SelectNumCalendars |
Select the total number of calendars stored.
| |
SelectNumJobs |
Select the total number of jobs stored.
| |
SelectNumTriggers |
Select the total number of triggers stored.
| |
SelectNumTriggersForJob |
Select the number of triggers associated with a given job.
| |
SelectPausedTriggerGroups |
Selects the paused trigger groups.
| |
SelectSchedulerStateRecords |
A List of all current SchedulerStateRecords.
If instanceId is not null, then only the record for the identified instance will be returned. | |
SelectStatefulJobsOfTriggerGroup |
Selects the stateful jobs of trigger group.
| |
SelectTrigger |
Select a trigger.
| |
SelectTriggerForFireTime |
Select the trigger that will be fired at the given fire time.
| |
SelectTriggerGroups |
Select all of the trigger group names that are stored.
| |
SelectTriggerJobDataMap |
Select a trigger's JobDataMap.
| |
SelectTriggerListeners |
Select the listeners associated with a given trigger.
| |
SelectTriggerNamesForJob |
Get the names of all of the triggers associated with the given job.
| |
SelectTriggersForCalendar |
Select the triggers for a calendar
| |
SelectTriggersForJob |
Select the triggers for a job
| |
SelectTriggersForRecoveringJobs |
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.
| |
SelectTriggersInGroup |
Select all of the triggers contained in a given group.
| |
SelectTriggersInState |
Select all of the triggers in a given state.
| |
SelectTriggerState |
Select a trigger's state value.
| |
SelectTriggerStatus |
Select a trigger status (state and next fire time).
| |
SelectTriggerToAcquire |
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.
| |
SelectVolatileJobs |
Get the names of all of the jobs that are volatile.
| |
SelectVolatileTriggers |
Get the names of all of the triggers that are volatile.
| |
SerializeJobData |
Remove the transient data from and then create a serialized MemoryStream
version of a JobDataMap and returns the underlying bytes.
| |
SerializeObject |
Create a serialized version of an Object.
| |
ToString | (Inherited from Object.) | |
TriggerExists |
Check whether or not a trigger exists.
| |
UpdateBlobTrigger |
Update the blob trigger data.
| |
UpdateCalendar |
Update a calendar.
| |
UpdateCronTrigger |
Update the cron trigger data.
| |
UpdateJobData |
Update the job data map for the given job.
| |
UpdateJobDetail |
Update the job detail record.
| |
UpdateSchedulerState |
Updates the state of the scheduler.
| |
UpdateSimpleTrigger |
Update the simple trigger data.
| |
UpdateTrigger |
Update the base trigger data.
| |
UpdateTriggerGroupStateFromOtherState |
Update all of the triggers of the given group to the given new state, if
they are in the given old state.
| |
UpdateTriggerGroupStateFromOtherStates |
Update all triggers in the given group to the given new state, if they
are in one of the given old states.
| |
UpdateTriggerState |
Update the state for a given trigger.
| |
UpdateTriggerStateFromOtherState |
Update the given trigger to the given new state, if it is in the given
old state.
| |
UpdateTriggerStateFromOtherStates |
Update the given trigger to the given new state, if it is one of the
given old states.
| |
UpdateTriggerStateFromOtherStatesBeforeTime |
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.
| |
UpdateTriggerStatesForJob |
Update the states of all triggers associated with the given job.
| |
UpdateTriggerStatesForJobFromOtherState |
Updates the state of the trigger states for job from other.
| |
UpdateTriggerStatesFromOtherStates |
Insert the job detail record.
|
Fields
Name | Description | |
---|---|---|
adoUtil | ||
dbProvider | ||
DefaultTriggersToAcquireLimit | ||
instanceId | ||
logger | ||
tablePrefix | ||
useProperties |
Properties
Name | Description | |
---|---|---|
CanUseProperties | ||
TriggersToAcquireLimit |
Gets the triggers to acquire limit.
|
See Also