Job queue failure email notification

FMC

Hi,

I have NAV 2017 and want to create an email if a job in the job queue fails.

is there a workflow for this or what will be the best way to achieve this

Thanks

FC

Juhl

You could start your codeunit from another codeunit and use the return value to determine if it was a success. Then send email from there.

Or schedule the job yourself from the run codeunit and set a error codeunit that sends the mail. (2017 only)

FMC

thanks for the info,

Please can you help advise what the actual code will be to aciveve this
"schedule the job yourself from the run codeunit and set a error codeunit that sends the mail"

how can you start a codeunit from another code unit (not something I have done before)

Juhl

IF NOT Codeunit.RUN THEN
Send mail;

https://msdn.microsoft.com/en-us/dynamics-nav/createtask-function

FMC

thanks, I will give this a go

RockWithNAV

Dont use this codeunit as another job queue because again there may a probability that this Job may stop. I too faced a situation like this and I wrote a SQL job for this.

FMC

RockWithNAV wrote: »

Dont use this codeunit as another job queue because again there may a probability that this Job may stop. I too faced a situation like this and I wrote a SQL job for this.

This makes sense,

is there anyway to achieve this in NAV witout running in a job queue

Juhl

Have the users watch the job que.
I usually make a pagepart in the role center for this.

Use built in NAV features not sql.

Everything can fail, even your car breaks down, does that stop you from driving it?

FMC

Juhl wrote: »

Have the users watch the job que.
I usually make a pagepart in the role center for this.

Use built in NAV features not sql.

Everything can fail, even your car breaks down, does that stop you from driving it?

I will try your way, are you able to give me a little more info on how to create this

Juhl

Create what ?

FMC

Juhl wrote: »

Create what ?

once I create a codeunit with this code

IF NOT Codeunit.RUN THEN
Send mail;

do I need to define the send mail parameter/variable and a template to use?

Juhl

Yes, the mailpart is up to you, i just wrote it for understanding. There are many ways to send mail.

Hint... Look at "Mail Item" table. It does it all...

FMC

thank you, I will give this a try

FMC

does anyone have any examples of how to achieve Job queue failure email notification

RockWithNAV

Hey,

Check this out

https://rockwithnav.wordpress.com/2016/10/03/configure-sql-email/

https://rockwithnav.wordpress.com/2016/10/03/sql-email-query/

Configure this for Job Queue failure.

Slawek_Guzek

Hi,

Did you try to create a codeunit/report which would look into Job Queue Entry and/or another Job Queue Log Entry log and send a notification or email when a Job Queue Entry with Status=Error is found? You would need some logic + modification of the Job Queue Entry table, or a custom table, to make sure you don't report the same error twice.

Once you have this report/codeunit working you could set it up as a separate job run every few minutes.


Also, if you are on NAV 2017, you could use Intergration events, create a subscriber function subscribing to Job Queue Entry table OnAfterModify event and send an email if a modification is made and the Status is set to Error. This solution would have the advantage that you would not have to have another job running, which someone could put into Hold.

Slawek