Stopping recdef jobs during maintenane

 4 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Leonard Courchaine
Veteran Member
Posts: 55
Veteran Member

    Does anyone have any thoughts/ideas about what they do during a maintenance (for example, LSF patching) to disable recdef jobs?  What we've found is that, as lawson is going down and coming up as part of, for example, a technology patch, these jobs will 'sneak in' and activate then when stoplaw gets run, the job(s) go into needs recovery.  Most Supply Chain jobs, for example, can be easily recovered but there are some jobs (MA126 and others) that go into needs recovery and can't simply be recovered as the issue is 'deeper'.  So we wonder what others are doing to avoid this from happening.  Thanks for your thoughts.

     

    (Since these jobs are in gen tables, my first though has been to run a script that will change the values of certain jobs to disable them at the time but wonder if there's a simpler way.  Note:  We have tons of these recdef jobs so turning them off/on, one by one, would be a royal pain.)

    JimY
    Veteran Member
    Posts: 510
    Veteran Member
      Yes it is a royal pain, but we go in and turn off any recdef jobs that would run during the time that we are applying patches. We are fortunate that ours is not a 24 hour operation so we try to schedule the down time when there are few jobs running. I haven't tried disabling them using Sql.
      Kwane McNeal
      Veteran Member
      Posts: 479
      Veteran Member
        An easier way is to set all your jobs to run in a certain jobqueue, and when you need to do maintenance, inactivate that queue.

        This also ensures those jobs have a later chance to run, if needed
        Leonard Courchaine
        Veteran Member
        Posts: 55
        Veteran Member
          Thanks to Jim and Kwane for such quick responses! Kwane, your solution is elegantly simple and I like elegant simplicity!! All our recdef jobs are indeed set to go to certain queues so this would be simple to test and then deploy.
          Thanks again and have a great day!
          Kwane McNeal
          Veteran Member
          Posts: 479
          Veteran Member
            My pleasure. For scripts, look into the following:
            Jqsubmit
            Jqaction
            Jqcontrol
            Jqstatus