3 Replies Latest reply on Oct 9, 2018 5:12 AM by Rajani Peddi

    Run Control M Job based on 2 calendars (Working day and Holiday Calendar)

    venkataraju saripella

      Hi Experts,

       

      I am new to control-M. I am not sure if this question is posted already, if so please excuse me and redirect me to the solution.

       

      Below is the requirement:

      1. A control M job should run on 25th of every month.

      2. If 25th is a non working day then the job should run automatically on the next working day and also should not run on Holidays(Based on Holiday Calendar).

      3. If 25th to end of the month is continuous holidays, then the job should run on next working day automatically even if it is falls on next month. In this special case, I need to capture the last working day of the previous month (maybe via a variable). (Ex. Job has to run on 25th, but due to continuous holidays the job runs on 1st of next month. In this case I need to capture the last working day of previous month, say 24th)

       

      Please guide me on how this can be achieved using Control M calendars. Should I maintain 2 different calendars to achieve this?

       

      Thanks,

      Venkataraju

        • 1. Re: Run Control M Job based on 2 calendars (Working day and Holiday Calendar)
          Ian Matthews

          Hi Venkataraju

               There shouldnt be a need to maintain two calendars for this.

          For the job in question, try setting its Scheduling up as shown below :-

          Please note - our Workdays calendar excludes weekends and public holidays

           

          In the Exception field, right click on the 25th and select 'order on this day, or next closest working day'

          The schedule for this job should then look like the following :-

           

          Please note - I have set the 27th, 28th and 31st December as holidays for this example, just to show that it will span two months.

                                 Decembers job is scheduled for 2nd Jan.

           

          Hope this is what you were looking for??

           

          Regards

          Ian 

          1 of 1 people found this helpful
          • 2. Re: Run Control M Job based on 2 calendars (Working day and Holiday Calendar)
            venkataraju saripella

            Hi Ian,

             

            Thanks for your reply. Yes this is exactly what I was looking for

            On the last working day logic (Requirement 3), I am handeling it outside of Control M manually.

             

            Thanks,

            Venkat.

            • 3. Re: Run Control M Job based on 2 calendars (Working day and Holiday Calendar)
              Rajani Peddi

              Hello Ian Matthews,

               

              I have a similar requirement of being able to run a job on a certain date every month. However the issue I am having is the job run time is between midnight and the control-m new day. Say my job has to run at 7am while the control-m new day is 10am. If I am to scheduling the job on 25th of each month ideally I would select '24th or the next business day' option and it works fine. But since 7am is the next calendar day the job wouldn't run as per requirement if 24th is beside a holiday.

               

              For example if 24th is a Friday I would want the job to run on Monday while the job would run on Saturday since 24th is still a business day. Similarly if 24th is a Sunday the job would run on Tuesday while I expect it to run on 25th Monday.

               

              I have been trying to look at all options available but found none. Any help is greatly appreciated.

               

              Thank you,

              Rajani