SqlServerDelegate Class

Initializes a new instance of the SqlServerDelegate class

Check whether or not a calendar exists.

Check whether or not a calendar is referenced by any triggers.

Clear (delete!) all scheduling data - all IJobs, ITriggers ICalendars.

Convert the JobDataMap into a list of properties.

Convert the JobDataMap into a list of properties.

Get the number of triggers in the given state that have misfired - according to the given timestamp.

Deletes all paused trigger groups.

Delete the cron trigger data for a trigger.

Delete a calendar.

Delete a fired trigger.

Delete all fired triggers.

Delete all fired triggers of the given instance.

Delete the job detail record for the given job.

Deletes the paused trigger group.

Deletes the state of the scheduler.

Delete the base trigger data for a trigger.

Determines whether the specified object is equal to the current object.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

Gets the boolean value from db presentation. Subclasses can overwrite this behaviour.

Gets the date/time value from db presentation. Subclasses can overwrite this behaviour.

Gets the db presentation for boolean value. Subclasses can overwrite this behaviour.

Gets the db presentation for date/time value. Subclasses can overwrite this behaviour.

Gets the db presentation for time span value. Subclasses can overwrite this behaviour.

Serves as the default hash function.

This method should be overridden by any delegate subclasses that need special handling for BLOBs for job details.

This method should be overridden by any delegate subclasses that need special handling for BLOBs. The default implementation uses standard ADO.NET operations.

Gets the select next trigger to acquire SQL clause. SQL Server specific version with TOP functionality

Gets the time span value from db presentation. Subclasses can overwrite this behaviour.

Gets the Type of the current instance.

Get the names of all of the triggers in the given state that have misfired - according to the given timestamp.

Get the names of all of the triggers in the given state that have misfired - according to the given timestamp. No more than count will be returned.

Initializes the driver delegate.

Insert the blob trigger data.

Insert a new calendar.

Insert a fired trigger.

Insert the job detail record.

Inserts the paused trigger group.

Inserts the state of the scheduler.

Insert the base trigger data.

Determines whether given trigger group already exists.

Check whether or not the given job is stateful.

Determines whether the specified trigger group is paused.

Check whether or not the given job exists.

Creates a shallow copy of the current Object.

Replace the table prefix in a query by replacing any occurrences of "{0}" with the table prefix.

Select a calendar.

Select all of the stored calendars.

Select the distinct instance names of all fired-trigger records.

Select the states of all fired-trigger records for a given trigger, or trigger group if trigger name is .

Select the states of all fired-trigger records for a given job, or job group if job name is .

Select the states of all fired-trigger records for a given scheduler instance.

Select the JobDetail object for a given job name / group name.

Selects the job execution count.

Select all of the job group names that are stored.

Select all of the jobs contained in a given group.

Get the names of all of the triggers that have misfired.

Get the names of all of the triggers in the given group and state that have misfired.

Select the total number of calendars stored.

Select the total number of jobs stored.

Select the total number of triggers stored.

Select the number of triggers associated with a given job.

Selects the paused trigger groups.

A List of all current SchedulerStateRecords.

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

Select a trigger.

Select the trigger that will be fired at the given fire time.

Select all of the trigger group names that are stored.

Select a trigger's JobDataMap.

Get the names of all of the triggers associated with the given job.

Select the triggers for a calendar

Select the triggers for a job

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.

Select all of the triggers contained in a given group.

Select all of the triggers in a given state.

Select a trigger's state value.

Select a trigger status (state and next fire time).

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.

Remove the transient data from and then create a serialized MemoryStream version of a JobDataMap and returns the underlying bytes.

Create a serialized byte[] version of an Object.

Returns a string that represents the current object.

Check whether or not a trigger exists.

Update the blob trigger data.

Update a calendar.

Update the job data map for the given job.

Update the job detail record.

Updates the state of the scheduler.

Update the base trigger data.

Update all of the triggers of the given group to the given new state, if they are in the given old state.

Update all triggers in the given group to the given new state, if they are in one of the given old states.

Update the state for a given trigger.

Update the given trigger to the given new state, if it is in the given old state.

Update the given trigger to the given new state, if it is one of the given old states.

Update the states of all triggers associated with the given job.

Updates the state of the trigger states for job from other.

Insert the job detail record.