do you mean these are cyclical jobs' interval details? in terms of query you can find them in definition table:
CMS_jobdef columns (fromtime,until,cyclic,cyclicint,run_times)
but i think searching tables is not recommended by BMC, try to play with the 'Control-M Reports', shall be very easy to get what you want.
2 of 2 people found this helpful
The "scheduling" of a job is a logical combination of many optional fields in the Job and Folder definition.
I.e. to schedule a job Control-M internal logic analyzes the Smart Folder the job is in, then the schedule of the job which can be made up of multiple fields with different optional relations.
Therefore, a job may be scheduled on one Monday but not another Monday.
To "report" on the best I've found is to use SQL and get all the job fields that optionally determine the schedule. This won't result in the schedule outcome (e.g. job scheduled on Monday 6th of Jan 2020) but will give you an idea of your schedules.
To get the actual schedules you need to run a Forecast for a specific day and then you see what jobs are scheduled on that day.
Here is the SQL I use for "report" of job schedule fields. (run this against CTM/EM database)
--All Jobs Report, with scheduling and run info. Includes Job Types and Plugin Types.
--Use seperate report to get details for each plugin type job that exists as those details are in VAR table.
select TBL.DATA_CENTER CTMNAME,
from DEF_TABLES TBL
JOIN (select TAG_NAME,JOB_ID,TABLE_ID from DEF_JOB_TAGS) TAG
ON (TAG.JOB_ID = JOB.JOB_ID and TAG.TABLE_ID = JOB.TABLE_ID)
JOB.TABLE_ID = TBL.TABLE_ID
ORDER BY TBL.SCHED_TABLE,JOB.APPLICATION,JOB.GROUP_NAME,JOB.JOB_NAME
Hope this helps.