Solved

Quartz scheduler

Posted on 2009-04-03
2
376 Views
Last Modified: 2012-05-06
Hi,
I want to call a stored proc every day at 9 pm and then the stored proc will actually update some of the tables. Based on the value of some of the columns i would want to send an email to some customers. So please can someone tell me how to do all this in quartz.
0
Comment
Question by:SunScreenCert
2 Comments
 
LVL 17

Accepted Solution

by:
Dejan Pažin earned 500 total points
ID: 24068007

You need the basic knowledge of quartz, which is not much. All you need is start a scheduler, add a job to it and a trigger to that job.

In your case the job is a method that calls the stored procedure and the trigger is a cron trigger.

This is how you start it every day at 9 pm:

0 0 21 ? * *

For the basics read the tutorial:

http://www.opensymphony.com/quartz/wikidocs/Tutorial.html


0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Java Flight Recorder and Java Mission Control together create a complete tool chain to continuously collect low level and detailed runtime information enabling after-the-fact incident analysis. Java Flight Recorder is a profiling and event collectio…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now