Automated notification of failed jobs

 8 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Terry P
Veteran Member
Posts: 234
Veteran Member
    We are running on Windows platform, 9.0.1

    We have batch jobs that are run daily (some three times a day) under a "generic user". If for whatever reason there is an error in running the scheduled job (like PA113), it will be put into a "Needs recovery" status under the Waiting Jobs tab of Job Schedule. The next time the job runs, it will just sit there until the prior one has been recovered or deleted.

    Is there a way to be notified if a job fails and is sitting there in a recovery status? I thought of a writing a ProcessFlow, but don't know if the file where this information is stored is accessible. How can we automate looking for jobs needing recovery - without writing custom scripts on the server?
    John Henley
    Posts: 3353
      https://www.lawsonguru.co...overy-notifications/
      Thanks for using the LawsonGuru.com forums!
      John
      Terry P
      Veteran Member
      Posts: 234
      Veteran Member
        Is GEN for Landmark only? I didn't see anything like that in LOGAN.
        John Henley
        Posts: 3353
          GEN is in LSF and Landmark.
          LOGAN is only for LSF.
          I'm guessing you are not seeing it in the query builder?
          If so, that is by design, and you need to input the query directly.
          If that's correct, let me know and I will post the query.
          Thanks for using the LawsonGuru.com forums!
          John
          EricS
          Veteran Member
          Posts: 80
          Veteran Member
            I can figure out the query, but in IPA how do you input the query directly? I've looked at the link above, and I don't see GEN, so I'm not sure what to do next.
            John Henley
            Posts: 3353
              What version of IPA, what version of LSF?
              Thanks for using the LawsonGuru.com forums!
              John
              EricS
              Veteran Member
              Posts: 80
              Veteran Member
                IPA and Landmark are 10, LSF is 9.0.1.10 Thanks!
                John Henley
                Posts: 3353
                  Since you are querying GEN in LSF, you need to use S3 Query node.
                  Thanks for using the LawsonGuru.com forums!
                  John
                  ClaireH
                  Basic Member
                  Posts: 5
                  Basic Member
                    We had the exact same issue, critical automated jobs were failing and causing others to back up behind them.  We wound up creating a crystal report that looks for any jobs in 'Needs Recovery' status and reports on them.  We use LBI to email that report out to the Admins tthree times a day so we are aware of any Portal jobs that fail.