How do you set up a jobstore with Quartz.net. The tutorial they have on the site is not that of help for me.
In this page though there are steps http://quartznet.sourceforge.net/tutorial/lesson_9.html I am not able to get how to set this one
org.quartz.jobStore.type = Quartz.Impl.AdoJobStore.JobStoreTX, Quartz
Thanks
Here's an adapted example of programmatic configuration from Quartz.NET's example 13:
NameValueCollection properties = new NameValueCollection();
properties["quartz.scheduler.instanceName"] = "TestScheduler";
properties["quartz.scheduler.instanceId"] = "instance_one";
properties["quartz.jobStore.type"] = "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz";
properties["quartz.jobStore.useProperties"] = "true";
properties["quartz.jobStore.dataSource"] = "default";
properties["quartz.jobStore.tablePrefix"] = "QRTZ_";
// if running MS SQL Server we need this
properties["quartz.jobStore.lockHandler.type"] = "Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz";
properties["quartz.dataSource.default.connectionString"] = "Server=(local);Database=quartz;Trusted_Connection=True;";
properties["quartz.dataSource.default.provider"] = "SqlServer-20";
// First we must get a reference to a scheduler
ISchedulerFactory sf = new StdSchedulerFactory(properties);
IScheduler sched = sf.GetScheduler();
You can also achieve the same thing with properties file based approach (the .config file).
Update for Quartz 3.1 and later
You can also use fluent Microsoft DI registration API introduced in Quartz.NET 3.1 if you have Microsoft dependency injection in use. See configuration guide for details.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With