Automated notification of failed jobs

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Terry P

Veteran Member

Posts: 234

9/26/2013 6:21 PM

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: 3364

New Poster

Engaged Reader

Avid Reader

9/26/2013 6:43 PM

https://www.lawsonguru.co...overy-notifications/

Terry P

Veteran Member

Posts: 234

9/27/2013 3:50 PM

Is GEN for Landmark only? I didn't see anything like that in LOGAN.

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

9/27/2013 4:33 PM

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.

EricS

Veteran Member

Posts: 80

9/27/2013 5:59 PM

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: 3364

New Poster

Engaged Reader

Avid Reader

9/27/2013 6:50 PM

What version of IPA, what version of LSF?

EricS

Veteran Member

Posts: 80

9/27/2013 7:23 PM

IPA and Landmark are 10, LSF is 9.0.1.10 Thanks!

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

9/27/2013 8:51 PM

Since you are querying GEN in LSF, you need to use S3 Query node.

ClaireH

Basic Member

Posts: 5

10/1/2013 6:14 PM

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.