Hi Dablu,

Can you give more information, may be you can explain the scenario as to how the jobs are to execute ?

Thanks,
Ankit

Hi Anirudh, You can try the below SQL query to find the list of jobs that executed (irrespective of failure or successful execution of the job) for the previous month. SELECT [APPLGROUP] ,[SCHEDTAB] ,[NODEID] ,[ODATE] ,[OSCOMPMSG] ,[JOBNAME] FROM [ctrlm700].[dbo].[CMR_AJF] WHERE (STATUS = 'Y' OR STA...