title: How to change quartz job scheduled time manually using sql?
body: <p>I am using Quartz job scheduler for running some jobs. Using java api I am managing the job.</p>
  
  <p>When I reschedule a job to different time using java,</p>
  
  <pre><code>   scheduler.deleteJob(jobName, jobGroupName);
  
     addJobsInScheduler(jobName, jobGroupName, triggerName,
                             triggerGroup, newTime, schoolName);
  </code></pre>
  
  <p>The job is getting rescheduled and triggered at the specified time.</p>
  
  <p>Now have a requirement in which I have to reschedule the job without UI(without Java api). </p>
  
  <p>From my understanding when I reschedule a job the following table entries getting updated.</p>
  
  <blockquote>
    <p>QRTZ_JOB_DETAILS</p>
    
    <p>QRTZ_TRIGGERS</p>
    
    <p>QRTZ_CRON_TRIGGERS</p>
  </blockquote>
  
  <p>So I manually updated the fire time in QRTZ_TRIGGERS,QRTZ_CRON_TRIGGERS. But the job is not triggered at the updated time.</p>
  
  <p>Is that possible to achieve my requirement?  </p>
  
  <p>Note: I am using sql server 2008 for my backend.</p>
  
  <p><a href="https://i.stack.imgur.com/nta7w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nta7w.png" alt="Table Structure:"></a></p>