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 Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,076 views 4 9
Read article

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