PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/24/2016 11:44 AM by  Kwane McNeal
Stopping recdef jobs during maintenane
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Leonard Courchaine
Private
Private
Veteran Member
(128 points)
Veteran Member
Posts:50


Send Message:

--
08/24/2016 7:16 AM

    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
    Private
    Private
    Veteran Member
    (1089 points)
    Veteran Member
    Posts:389


    Send Message:

    --
    08/24/2016 9:01 AM
    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
    Private
    Private
    Veteran Member
    (1197 points)
    Veteran Member
    Posts:399


    Send Message:

    --
    08/24/2016 9:34 AM
    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
    Private
    Private
    Veteran Member
    (128 points)
    Veteran Member
    Posts:50


    Send Message:

    --
    08/24/2016 10:01 AM
    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
    Private
    Private
    Veteran Member
    (1197 points)
    Veteran Member
    Posts:399


    Send Message:

    --
    08/24/2016 11:44 AM
    My pleasure. For scripts, look into the following:
    Jqsubmit
    Jqaction
    Jqcontrol
    Jqstatus
    You are not authorized to post a reply.