Solved

Quartz scheduler

Posted on 2009-04-03
2
388 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

624 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