ansaurus

Question

Answer 1

+2 A:

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).

Marko Lahma 2009-09-29 12:35:00

Marko thanks for your response. I created all the tables but in the QRTZ_Triggers table the start_Time and End_Time are big int columns how to I specify a Start time as 11:30 or 14:25?And after getting the instance of Scheduler do I need to loop through the triggers from the database?? or do u have any example for that please

acadia 2009-09-29 19:43:19

You should do all changes via scheduler interface, you should not change the table contents directly in database. Triggers and job details are persisted in database if you use JobStoreTX.

Marko Lahma 2009-10-01 13:21:37

Answer 2

A:

Marko:

What do you mean by the "scheduler interface?" I have downloaded the solution but there is no GUI project. The solution has a two class library projects, a console app and a windows service. As far I can tell, the console just starts the same process that the service would.

Thanks for your help with this.

Joel 2009-11-27 07:27:55

For future visitors of this thread, I'll assume that Marko by "scheduler interface" didn't mean a visual interface (e.g. a GUI) but the IScheduler interface that ships with Quartz.net. One can implement their own scheduler implementation or use one of the included concrete implementations inside of Quartz.Implhope this helps :)

bakasan 2009-12-17 22:58:18

Answer 3

A:

well can anyone tell me where i can find this famous 'Example 13' for Quartz.net? beacause i want to use adojobstore and i don't have any idea how to do that! thanks ps: i made the properties configuration

edit:i fount it in quartznet1_2\src\Quartz.Examples\

aleo 2010-03-12 10:00:38

ansaurus

tags:

views:

answers:

Configuring ADOJobStore with Quartz.net

related questions