While checking the DB data, I came across the table CLUSTEREDJOB. Can someone explain what is the data contained in this ? What is the job type and job key is being entered here ?
AFAIK, no specific scheduled job was set by me using JIRA.
Jira will use this table to keep track of how often to run a number of different processes and tasks. This is not a complete list, but here are a few examples:
Each of these tend to be created by Jira itself or a system plugin in Jira that can then this table to keep track of how often Jira or the plugin itself should be running some particular scheduled task/job/etc.
Even in a brand new, vanilla Jira without any user plugins, you can still expect to see at least a few entries in this table from system plugins. Most of these are utilizing a cron value for the interval and/or the interval in milliseconds, but this table can also be used to track the last run time, which I believe is in a unix epoch time format.
I hope this helps.
I started the H2 databases via the console, but unable to see this table. The db object navigator doesn't show all the tables. Which aliases should i use to see and access this table and update this query?
UPDATE clusteredjob SET interval_millis=86400000 WHERE job_runner_key='com.atlassian.jira.plugins.dvcs.scheduler.DvcsScheduler';
I wish to change the frequency of the DVCS job run. I was able to change it in the hsql database but the values are being overwritten each time I :
My updates are not persisting after jira restart. the values are getting reset to interval = 3600000. DVCS scheduler still shows interval as 1 hour even after these steps. I want to change the interval to 5min
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events