How is timesheet plugin subscription job run without TIMESHEET_SUBSCRIPTION job?

We had a user subscribe to a timesheet report.  After user left, I removed his subsription via Admin --> Add-ons --> Timesheet Subscriptions.  I can see that the subscription row has been removed from the AO_E24DEA_TIMESHEET_JOB_CFG table.

However, the jira.timesheet.plugin.job.TimesheetJob job still runs via scheduler and fails daily with "Timesheet Job Configuration not found2" (2 being the ID of the subscription row that was removed).

Leaving aside the question of why the scheduler hasn't been cleaned up properly as part of removing the subscription, I am struggling to understand where this job is kicked off and where this parameter is passed.

It was mentioned on the Timesheet Bitbucket site that one would need to delete from qrtz_job_details where job_name = 'TIMESHEET_SUBSCRIPTION'.  However, that table does not have a TIMESHEET_SUBSCRIPTION job.  It only has 1 row for SEND_SUBSCRIPTION job, which I'm lead to believe is limited to filter subscriptions.

I cannot find anything off-hand in any scheduler tables that is kicking off this timesheet job or passing the ID that's been removed.

Could someone let me know how this is hanging together behind the schenes please so that we can clean it up manually and get rid of the error?



1 answer

According to Atlassian, the Quartz scheduler is no longer used in JIRA 7.1 (although the corresponding tables are not dropped or even truncated as part of the upgrade).  The 'clusteredjob' table is used instead.  Cleaning that one out against timesheet and filtersubscription tables does the trick of failing jobs for non-existing entities disappearing from being scheduled.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,304 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot