5 Replies Latest reply on Sep 24, 2019 9:05 AM by Per Hansa

    Calendar Created on Job - Where Is Calendar Info Stored?

    Per Hansa
      Share This:

      If a user creates a calendar directly on a job, that is, from the Scheduling tab chooses, for example, "Schedule" -> "Month Days" and clicks several dates, where does Control-M store that calendar information? SQL? XML? Somewhere else?

       

      Thanks,

      Per

        • 1. Re: Calendar Created on Job - Where Is Calendar Info Stored?
          Bhanu Prakash Badiginchala

          Its in the SQL for Control-M. But, if you export the job definitions for reference or promotion, it should also be in the XML.

          • 2. Re: Calendar Created on Job - Where Is Calendar Info Stored?
            Per Hansa

            Bhanu:

             

            Thanks for responding.

             

            I have exported jobs where the schedule has been defined on the job instead of referencing a regular or rule based calendar. What is the XML tag that indicates the days on which a job should execute?

             

            Thanks,

            Per

            • 3. Re: Calendar Created on Job - Where Is Calendar Info Stored?
              Paul Robins

              Hi Per,
              The 'Month Days' will be in the DAYS property of the JOB tag.
              'Week Days' will be in the WEEKDAYS property of the JOB tag.

              A list of parameters can be found in the folder.xsd file in the \bin folder of the EM install.

               

              <xs:complexType name="TagData">

              <xs:attribute name="NAME" type="xs:string" use="optional"/>

              <xs:attribute name="TAG_NAME" type="xs:string" use="optional"/>

              <xs:attribute name="MAXWAIT" type="xs:string" use="optional"/>

              <xs:attribute name="DAYS_AND_OR" type="xs:string" use="optional"/>

              <xs:attribute name="JAN" type="xs:string" use="optional"/>

              <xs:attribute name="FEB" type="xs:string" use="optional"/>

              <xs:attribute name="MAR" type="xs:string" use="optional"/>

              <xs:attribute name="APR" type="xs:string" use="optional"/>

              <xs:attribute name="MAY" type="xs:string" use="optional"/>

              <xs:attribute name="JUN" type="xs:string" use="optional"/>

              <xs:attribute name="JUL" type="xs:string" use="optional"/>

              <xs:attribute name="AUG" type="xs:string" use="optional"/>

              <xs:attribute name="SEP" type="xs:string" use="optional"/>

              <xs:attribute name="OCT" type="xs:string" use="optional"/>

              <xs:attribute name="NOV" type="xs:string" use="optional"/>

              <xs:attribute name="DEC" type="xs:string" use="optional"/>

              <xs:attribute name="DAYSCAL" type="xs:string" use="optional"/>

              <xs:attribute name="WEEKSCAL" type="xs:string" use="optional"/>

              <xs:attribute name="CONFCAL" type="xs:string" use="optional"/>

              <xs:attribute name="SHIFT" type="xs:string" use="optional"/>

              <xs:attribute name="SHIFTNUM" type="xs:string" use="optional"/>

              <xs:attribute name="RETRO" type="xs:string" use="optional"/>

              <xs:attribute name="DATE" type="xs:string" use="optional"/>

              <xs:attribute name="DAYS" type="xs:string" use="optional"/>

              <xs:attribute name="WEEKDAYS" type="xs:string" use="optional"/>

              <xs:attribute name="ACTIVE_FROM" type="xs:string" use="optional"/>

              <xs:attribute name="TAGS_ACTIVE_FROM" type="xs:string" use="optional"/>

              <xs:attribute name="ACTIVE_TILL" type="xs:string" use="optional"/>

              <xs:attribute name="TAGS_ACTIVE_TILL" type="xs:string" use="optional"/>

              <xs:attribute name="LEVEL" type="xs:string" use="optional"/>

              </xs:complexType>

              1 of 1 people found this helpful
              • 4. Re: Calendar Created on Job - Where Is Calendar Info Stored?
                Ilyas Shaikh

                Hi Per Hansa,

                 

                If I understand you correctly, if you are are not selecting any predefined calendar in scheduling (like using calendar or based on calendar options) then the schedule with different dates won't be treated as calendar configuration.

                 

                As Bhanu Prakash Badiginchala said, the scheduling details are stored in DEF_VER_JOBS table on EM or you will find the details in xml after exporting the job.

                 

                In XML, all jobs properties are stored in <JOB> ...</JOB> tag and the scheduling details will be as follows:

                 

                SHIFTNUM="+00" SHIFT="Ignore Job" DAYS_AND_OR="O" DEC="1" NOV="1" OCT="1" SEP="1" AUG="1" JUL="1" JUN="1" MAY="1" APR="1" MAR="1" FEB="1" JAN="1" WEEKDAYS="6" TIMEFROM="0700" MAXRUNS="0" MAXDAYS="0" AUTOARCH="1" MAXRERUN="0" MAXWAIT="0"

                 

                Regards,

                Ilyas Shaikh

                3 of 3 people found this helpful
                • 5. Re: Calendar Created on Job - Where Is Calendar Info Stored?
                  Per Hansa

                  Bhanu, Paul & Ilyas:

                   

                  Thank you all for your helpful responses. I regret not being able to mark multiple answers as "Correct" because all had useful info.

                   

                  Per