Solved

Quartz scheduler

Posted on 2009-04-03
2
381 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…
This video teaches viewers about errors in exception handling.

776 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