Solved

Quartz scheduler

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Creating and Managing Databases with phpMyAdmin in cPanel.
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
This video teaches viewers about errors in exception handling.
Suggested Courses

751 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