Scheduler table and what is stores

Requirement:

The below data sheds some light on the different tables that are present for the scheduler and what each table contains.

Explanation:

Please find the table name and what they store: (table name: what they store)

a) Jireportjob: Scheduled jobs list (report and dashboard) from Schedules tab

b) Jireportjobalert: job status notifications settings from “Notifications” tab

c) Jireportjobmail: email notifications settings from “Notifications” tab

d) Jireportjobmailrecipient: all email recipients from “Notifications” tab

e) Jireportjobrepodest: output destination options from “Output Options” tab

f) Jireportjoboutputformat: output format type from “Output Options” tab

g) Jireportjobparameter: parameter name and values from the “Parameters” tab

h) Jireportjobtrigger: trigger information including time zone, calendar exclusions, start and end date behind the “Schedules” tab

i) Jireportjobsimpletrigger: Settings for recurrence type = Simple from the “Schedules” tab

j) Jireportjobcalendartrigger: Settings for recurrence type = Calendar from the “Schedules” tab