How to set date and time in Quartz Schedular from database

Question

I am trying to set date and time from database in Quartz Schedular but is unable to do so. Please help me out.

Here is my code:

public class CroneScheduler { public CroneScheduler() throws Exception { SchedulerFactory sf = new StdSchedulerFactory(); Scheduler sche = sf.getScheduler(); sche.start(); JobDetail jDetail; jDetail = new JobDetail("Newsletter", "NJob", MyJob.class); //"0 0 12 * * ?" Fire at 12pm (noon) every day //"0/2 * * * * ?" Fire at every 2 seconds every day CronTrigger crTrigger = new CronTrigger("cronTrigger", "NJob", "0/2 * * * * ?"); sche.scheduleJob(jDetail, crTrigger); } }

Please explain what you mean by "unable to do so". Also, how does the title relate to the code? Where are you trying to "set the date and time"? Did you mean you want to schedule something to happen at a specific date and time? — Jim Garrison
– Jim Garrison, Commented Jun 27, 2018 at 5:14
Yes, I want that whenever I insert date and time in database it should hit to the quartz schedular and at that particular date and time data can be send. — Tanisha Agarwal
– Tanisha Agarwal, Commented Jun 27, 2018 at 8:41

flyingfox · Accepted Answer · 2018-06-27 04:41:26Z

If the version of quartz is 1.7.2,then you can use below code:

public void resetJob(String expression){ ApplicationContext applicationContext = WebApplicationContextUtils.getRequiredWebApplicationContext(context); Scheduler scheduler = (Scheduler) applicationContext.getBean("testScheduler"); try { CronTriggerBean trigger = new CronTriggerBean(); trigger.setCronExpression(expression); trigger.setName("testJobTrigger"); trigger.setGroup(Scheduler.DEFAULT_GROUP); trigger.setJobName("testJobDetail"); scheduler.rescheduleJob("testJobTrigger", Scheduler.DEFAULT_GROUP, trigger); } catch (SchedulerException | ParseException e) { e.printStackTrace(); } }

If the version of quartz is newer than 1.7.2,you can use below code:

public void resetJob(String expression){ ApplicationContext applicationContext = WebApplicationContextUtils.getRequiredWebApplicationContext(context); Scheduler scheduler = (Scheduler) applicationContext.getBean("testScheduler"); CronTriggerImpl trigger = null; try { TriggerKey triggerKeys = TriggerKey.triggerKey("testJobTrigger",Scheduler.DEFAULT_GROUP); trigger = new CronTriggerImpl(); trigger.setCronExpression(expression); trigger.setKey(triggerKeys);//keep key the same scheduler.rescheduleJob(triggerKeys,trigger); } catch (ParseException | SchedulerException e) { e.printStackTrace(); } }

Collectives™ on Stack Overflow

How to set date and time in Quartz Schedular from database

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related