cancel
Showing results for 
Search instead for 
Did you mean: 

email code to include the job description

former_member199052
Participant
0 Kudos

Hi Experts,

I have a mail job that is triggered from a max runtime event.  The email is sent, but does not include the job description.

Code:

<html>

     <body>

     <h3><font face="Tahoma">The job ${Job_Description} has been running for too long and has been killed.</font>  </h3>

     <p> Job Id: <strong><font color="#ff0000">${Job_Id}</font></strong></p>

     <p> Job Link:<font color="#ff0000">   <strong>${Job_link}${Job_Id}</strong></font></p>

     <p> Regareds,

      <br> Cronacle Administration</p>

      <hr>

</p>

          </body>

</html>

Can anyone tell me why the job description is not showing in the email?  I appreciate all your help!

Best Regards,

Rick

Accepted Solutions (1)

Accepted Solutions (1)

former_member206885
Participant
0 Kudos

Hi,

Can you check the parameter value of the job description. Try the below one

=Query.getString('select Job.Description from Job where Job.JobId = ? ',[waitEvents.<eventname>.raiserJobId])

Thanks,

Tinku

former_member199052
Participant
0 Kudos

Hi Tinku,

Thank you for your response.  I got sidetracked on another project.  I will give that a try and post back.

Best Regards,

Rick

former_member199052
Participant
0 Kudos

Hi Tinku,

I was able to implement the query and it works perfectly.  Thanks so much for your help!  I marked as correct answer and closed the thread.

Best Regards,

Rick

Answers (0)