Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

what is the data contained in CLUSTEREDJOB table of JIRA 8.1 version

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.

1 answer

0 votes
Andy Heinzer Atlassian Team May 20, 2019

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:

  • Interval used to sync with external user directories (Active Directory / LDAP)
  • Jira Service Desk SLA audit cleanup
  • Service Desk mail handler check interval
  • DVCS synchronization intervals
  • UPM check for updated plugin versions in Marketplace
  • Jira Filter subscriptions interval to send these out

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.

Andy

How to run this update query: https://confluence.atlassian.com/jirakb/how-to-change-the-interval-or-schedule-of-the-dvcs-repositories-sync-962980024.html

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 :

 

  1. stop jira
  2. start hsql db engine
  3. change values for interval, next run in clusteredjob table
  4. stop hsql db engine
  5. start jira

 

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

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you