Ado JobStore use!
Posted
by aleo
on Stack Overflow
See other posts from Stack Overflow
or by aleo
Published on 2010-03-11T15:53:09Z
Indexed on
2010/03/23
11:23 UTC
Read the original article
Hit count: 592
well i'm new in Quartz i'm following this tutorial
and i configured my scheduler instance and quartz to use this properties:
properties["quartz.jobStore.lockHandler.type"] = "Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz";
properties["quartz.jobStore.driverDelegateType"] = "Quartz.Impl.AdoJobStore.SqlServerDelegate, Quartz";
properties["quartz.jobStore.dataSource"] = "default";
properties["quartz.dataSource.default.connectionString"] = "Server=loclahost;Initial Catalog=aleo;Persist Security Info=True;User ID=userid;Password=password";
properties["quartz.dataSource.default.provider"] = "SqlServer-20";
properties["quartz.jobStore.type"] = "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz";
properties["quartz.jobStore.useProperties"] = "true";
properties["quartz.jobStore.tablePrefix"] = "QRTZ_";
ISchedulerFactory schedFact = new Quartz.Impl.StdSchedulerFactory(properties);
IScheduler sched = schedFact.GetScheduler();
sched.Start();
but what's next? i am new on C# but if someone explain to can understand :)
and my question are how i will add jobs and triggers and stuff to the database?
i also created the tables given in the Database/tables folder that comes with Quartz API thanks.
© Stack Overflow or respective owner