IPA to show jobs in Needs Recovery

Does anyone have a IPA flow that would see if a job is in needs recovery, and send e-mail to Lawson Admins ?

The IPA would run every 15 minutes. We are just looking at a way to communicate to users when a job goes into recovery (or invalid parameters).

Find more posts tagged with

Process Automation (IPA) - General Discussions

Comments

d-hofmann

We have a Smart Note that runs once an hour between 7 am and 6 pm. It notifies the Lawson Admins if any jobs are in the gen.QUEUEDJOB table with a status of 34. One problem you might have is that the Queuejob table stores the user by the NT number, so to determine which user to notify you need to look it up in the listusermap.

Here is a list of the statuses:

The $LADBDIR/GEN/QUEUEDJOB status codes are outlined below.

•0 : Running

•30 : Waiting - To recover job.

•31 : Waiting Step

•32 : Waiting On Time

•33 : Waiting Recovery

•34 : Needs Recovery

•35 : Invalid Parameters

•36 : Queue Inactive

•37 : Hold

•60 : Recurring Skipped

•61 : Recovery Deleted

•62 : Cancelled

•63 : Normal Completion - To delete job.

If you work out the IPA, I would love to see it.

Thanks,

Melissa

unknown

We have an IPA flow that queries the GEN data area and gets all jobs in certain status (using the codes above) for 31 and 34 . Then gets various information about the jobs found, by job number, and then sends an email to a IPA Task assignment to the SysAdmin, backup, and a lead analyst. We capture the user that submitted the job, job name, time submitted etc included in the email to make investigation easier.

I can send a copy if you want, email darringt@Nemours.org

unknown

You can also use the On Error tab in the IPA Node to email anyone if an error happens at any point in the process.

keiths

Could you please send me a copy as well at sjibb@caasco.ca?

unknown

Can easily be done in IPA. Hastleless. DM me. I will share some information that can be useful to you.

unknown

Good Morning,

I am not new to Lawson; but very new to IPA - I went through the basic training about 2 months ago. We only Have one flow active; but think this Job Status IPA would be helpful. Also we recently Moved to the Infor Cloud from On premise. Any help would be appreciated

laura-patenaude

Hi - I was searching for an IPA that would do this same thing - but most of the posts I found are 1-2 years old. I think I'd take a shot at responding to this one and ask if you got this working and if you'd be willing to share your flow?

Thanks so much in advance,

Laura

serafino

We are on-prem UNIX and run "jqstatus -r" in a cron job. Been doing that for 20 years. It works perfectly well.

laura-patenaude

Hi Sal - we currently have a process in place as well - Unix script that executes jqstatus and generates a flat file that is input to a Cobol program that reads the data and separates it into separate files by job queue and then generates an email to the appropriate group (AP, IC, Finance, etc) based on the job queues. I'm just trying to get rid of all that "noise" and put something into IPA - we are trying to convert as much as possible into IPA to try to standardize our processes. Thanks for the info though!

dEPM-670_Series_Part 4_FICA in Medicare.mp4

unknown

Hi L, if you have not already received darringt's flow, this should be easy to do in IPA by querying the QUEUEDJOB table in the GEN database, same as Melissa's smartnote process does. You can see her post for a list of valid job statuses as well. Additionally, FYI - a job that is executing will have a status of zero in QUEUEDJOB.

0911060553270289.pdf

unknown

I'd like a copy of that flow Darringt, we could use it at our org. Will email you thanks.

laura-patenaude

Thanks for the info. No - I haven't received the flow - but based on the information in this thread, I'm going to try to build something on my own.

laura-patenaude

King - if you have a copy - would you be willing to share with me? If you don't have it - I can share mine with you once I get something together that works. Thanks!

Copyright © 2025 Infor. All rights reserved.