Update scheduled job details

Requirement:

The customer wish to batch update the scheduled job details from the backend repository database. There are large number of jobs need to be updated which is why they want to use the batch script instead of manually update from UI. They are asking to provide some guide on the table structure for the scheduled jobs.

Solution:

You should be able to find all the scheduled jobs from your repository database table: jireportjob. To identify the jobs you want to change, run the query below: 

select * from jireportjob;

In inside the table jireportjob, each job is linked to the owner which is is user id whoever scheduled that job. To find the user id, you can query the table jiuser with the following query: 

select * from jiuser;

Update the table jireportjob for those jobs which you want to change. Use the query as below: 

update jireportjob set owner = xxxx where id = xxxx;

If you need to update the mail notification details, you can find there is a mail_notification id from table jireportjob which linked to the other two tables:

jireportjobmail and jireportjobmailrecipient.

Update the email notification details for the report job you need to modify. Use the query as following: 

select * from jireportjobmail;
select * from jireportjobmailrecipient;