Configuring Quartz.Net with an ADO.Net Job Store (AdoJobStore) – Part 2
In Part 1 we set up our database so that we could use it as a job store for Quartz.Net. Now, we need to set up our scheduler job store properties to use said database. Here are the most common properties and values that need to be set in order to get the scheduler to use the database as its job store:
You can set these properties in your config file, but the specific file will depend on whether you are using the default configuration file or something else. If you are using the default (distribution) settings, these properties will go in your quartz.config file.
That’s all there is to setting up an AdoJobStore. Start up your service and take a look at the event log to see if the scheduler started up correctly.
| Property | Value |
| quartz.jobStore.type | Quartz.Impl.AdoJobStore.JobStoreTX, Quartz |
| quartz.jobStore.dataSource | default |
| quartz.jobStore.tablePrefix | QRTZ_ |
| quartz.jobStore.clustered | true |
| quartz.jobStore.lockHandler.type | Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz |
| quartz.jobStore.driverDelegateType | Quartz.Impl.AdoJobStore.SqlServerDelegate, Quartz |
| quartz.dataSource.default.connectionString | Server=localhost;Database=youeverseethefly;Uid=brundle;Pwd=fly; |
| quartz.dataSource.default.provider | SqlServer-20 |
| quartz.jobStore.useProperties | true |
That’s all there is to setting up an AdoJobStore. Start up your service and take a look at the event log to see if the scheduler started up correctly.