C# – How to insert JOB/TRIGGER on database using Quartz.NET

cquartz-schedulerquartz.net

I´m using Quart.NET (http://quartznet.sourceforge.net/) to scheduler my jobs.
This works perfectly, I can run create job and trigger programatically but I would like to use database to store and create new triggers.

The quartz.config changed file is bellow:

quartz.jobStore.type = Quartz.Impl.AdoJobStore.JobStoreTX, Quartz
quartz.jobStore.driverDelegateType = Quartz.Impl.AdoJobStore.OracleDelegate, Quartz
quartz.jobStore.tablePrefix = QRTZ_
quartz.jobStore.dataSource = myDS
quartz.dataSource.myDS.connectionString = * my oracle connection string ****
quartz.dataSource.myDS.provider = OracleODP-20
quartz.jobStore.useProperties = true

I'm using the solution sample of Latest stable version of Quartz.NET is 2.0.1 called Quartz.Server.2010, the project play normally and execute SELECT in table a each 15 seconds (more or less), but how I INSERT data in the quartz tables?

My database has been configured using the script tables_oracle.sql

I would not execute INSERT manually in the tables, because the schema quartz of database is very dificult.

I have a other project WEB where do I would use to schedule new jobs, this project will insert the data in tables and my project server Quartz.Server.2010 will been execute.

Can I use the method CronExpression to schedule jobs a each 1 minute? like below:

Quartz.CronExpression cron = new Quartz.CronExpression("0 0/1 * 1/1 * ? *");

But i would like to put it in database, to be consumed by quartz server, and don't run in my web project.

Thanks Friends,

Best Answer

You configure your web server to use the same settings as your Quartz Server and you initialise your scheduler the same way, but don't actually start the scheduler (otherwise the jobs will start to run on the webserver).

When you are creating jobs using the API make sure you remember to call .StoreDurably()

See my answer to this SO question for more details of the syntax.

Related Solutions

Quartz.Net Job Storage Query

you can use AdoJobStore.
Quartz.net will use a set of tables with prefix QRTZ_ (you can change it if you want) in your database to stored jobs, triggers and status of these objects.
I guess you want to have a table in your DB where you're going to keep extended information about your schedules, right?
You won't access Quartz.net table directly cause you will use the APIs provided by Quartz.net.

The process to create a job detail and trigger is straightforward and described very well in the tutorials.

To configure your app to use the AdoJobStore you have to specify few informations in your app.config file. Here is an example:

  <quartz>
    <add key="quartz.scheduler.instanceName" value="myApp" />
    <add key="quartz.scheduler.instanceId" value="MyApp" />
    <!-- Configure Thread Pool -->
    <add key="quartz.threadPool.type" 
                  value="Quartz.Simpl.SimpleThreadPool, Quartz" />
    <add key="quartz.threadPool.threadCount" value="10" />
    <add key="quartz.threadPool.threadPriority" value="Normal" />
    <!-- Configure Job Store -->
    <add key="quartz.jobStore.misfireThreshold" value="60000" />
    <add key="quartz.jobStore.type" 
                  value="Quartz.Impl.AdoJobStore.JobStoreTX, Quartz" />
    <add key="quartz.jobStore.useProperties" value="true" />
    <add key="quartz.jobStore.dataSource" value="default" />
    <add key="quartz.jobStore.tablePrefix" value="QRTZ_" />
    <add key="quartz.jobStore.lockHandler.type"  
              value="Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz" />
    <add key="quartz.dataSource.default.connectionString" 
        value="Server=SVSQL2008;Database=QuartzNet1;Trusted_Connection=True;" />
    <add key="quartz.dataSource.default.provider" value="SqlServer-20" />
   </quartz>

There are few things to keep in mind depending if you're hosting Quartz.net in a web application or a service or winform app. The best approach is to create SchedulerFactory and Scheduler as singleton. You can gather some more infos here.

UPDATE:

First of all you have to create Quartz.net tables (see Step 1) and then you'll have to create a few indexes for optiomization (see bottom of the page).

Since you're going to submit your jobs using the web app but you're not using that app for the quartz.net events (triggers) you don't need to start the scheduler. There are few steps to follow on this side:

you have to change the thread pool type to ZeroSizeThreadPool

<add key="quartz.threadPool.type" 
                   value="Quartz.Simpl.ZeroSizeThreadPool, Quartz" />

and you have to define your StdSchedulerFactory and Scheduler singleton. You can start during the application (asp.net) bootstrap.

You're never going to start the Scheduler (your windows service is going to use that).

Another thing to remember is you're going to need share your job between your web and your windows service, so it would be better to keep it in a separate assembly.

You mentioned you're storing some infos in one of your table. You still need to have to submit your jobs and trigger which will be persisted in Quartz.net tables.

Related Topic