Batch job failures-email notification

[Former Member]

Hi all,

I have to make a program that should post email to multiple recipients based on the batch job failures. i do have a routine to post emails. but can u people help me with the logic to using that with the basis of job names.

thanks,

kiran.

[Former Member]

The Batch names are stored in the table APQI.

You can query that table and find the status (QSTATE) and accordingly build the logic to send the email to whoever you want.

Regards,

ravi

[Former Member]

Take a look at table <b>APQI</b>

I believe that the field <b>GROUPID</b> denotes the jobname. You can also give the <b>PROGID</b> (programme name) along with it!

I think you will get the status of the job from the field <b>APQI-QSTATE</b>

Do verify these....

[RichHeilman]

I guess I would create a custom table for storing the job name and the email addresses that need to be notified. Job name would be the key of the table, and another field for holding the email address.

<b>Job Name      Email Address</b>

Z_YOUR_JOB    [email protected]
z_YOUR_JOB    [email protected]

Then you can retrieve the email addresses by job name and send the emails.

select * into table icusttable
     from zcusttable
            where job_name = <the_job_name>.

loop at icusttable.

mailrec-receiver = icusttable-email.
mailrec-rec_type  = 'U'.
append mailrec.

endloop.

Regards,

Rich Heilman

[Former Member]

Hi Rich Heilman,

Thanks for the info. the problem is there are batch jobs which deal with the interfaces of 5 different countries and based on those jobs i have to send the emails. can u plz help me with that logic.

thanks in advance,

kishore.

[RichHeilman]

You already have the logic for checking the status of the jobs right? You also know how to send emails, right? What logic do you need help with.

Regards,

Rich Heilman

[Former Member]

thanks mate,

got it.

[Former Member]

Hi,

In that case you need to maintain the country also along with other information in the ztable and based on the SY_LANGU you can decide which one went wrong.

Regards,

Suman