Solved

Quartz scheduler

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
html input clean up 3 47
Error trying to install RTMT Win7 5 38
Whether to use true/false, yes/no or 0/1 11 50
java stored proc example 9 18
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

930 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

10 Experts available now in Live!

Get 1:1 Help Now