How to email output from Background Jobs
One of my Customers has a regularly scheduled job with spool (SP01) output. They have asked if it could be be emailed to a group email address. The address management is nice and easy in this case; they manage the mail group, adding and deleting email addresses as people move in and out of the group. But how do we send the spool output as email ?
Go into transaction SM37 (Job Overview) and search for the job that creates the output you wish to mail. You need to make sure you find a scheduled, released or ready version of the job as you can’t do this with an existing spool output.
Select the job in question, then select Job –> Change from the menu (or CTRL+F11). This gives you the Change Job detail screen. Select the button labelled Spool list Recipient This will show the Recipeint Determination Dialog.
Put the target address into the Recipient field. Note that this doesn’t have to be an email address; you can use email, fax or X.400 messaging. Depending on which method you choose, you can add extra options by selecting the appropriate button at the bottom of this dialog. Select the tick when you’re done and you’ll be returned to the Change Job detail screen.
Don’t forget to save your changes on this screen as well.
There’s lots of errors possible with email. If the users don’t get the email, or there is a problem with it, checking that the output was written to the spool (use transaction SP01 or SM37).
If the email is truncated when compared to the spool output, check OSS Note329537 – Spool cut off at 1000 lines when sent to recipient.
very informative. I tried to receive when the job is failed.but that job never failed so i have cancelled the job. but still i did get get an email from sap.
i followed all your steps.
A couple of things to check...
1) did the job produce any output to be mailed ?
2) is there anything in transaction SCOT indicating whether the SAP system actually sent a mail ?
If your SAP system did send the mail, then you need to start looking at the email subsystem. Unfortunately, I can't really help wit that - I've set them up on both UNIX and Windows servers, but I'm definitely not an expert on them.
This may sound stupid, but I fell for it once before.... if your Job Scheduling is being run from a Solution Manager system, make sure you are doing the trouble shooting on the system that the job ran on 🙂
you might be correct. I could not check SOST since i dont have access. Then only i can confirm you. I will work it out with basis onSCOT and RSCON JOB. Thanks. I keep trying ..appreciate your reply.
I have cancelled the job but i could not see entry in SOST itself. Why?
PS:-Do you know what are the events are pushed to SOST/ i am interested to find out those.
SM37 cannot sent the email accordingly.
I could not see the records in SOST.
I have setup a job in SM36 with "Spool List Recipient" containing my yahoo email (below).
Then I setup the Print Parameters to Spool only, but I do not get any email with the report. I just see the spool created.
Then if I change the "Time of Print" to "X Print out Immediately", I get the error below.
Do you know what this issue could be?
Anything would help.
P.S. I dont see anything in SOST
I followed the instruction, it works.
But I got two documents for one job. one is pdf, the other one is htm.
Is there an existing parameter to specify it?
I need an email output from Background Jobs in excel/alv format and send it to multiple id's. Is there any way to do this?
Did get email to only one user but its in html format.
Hi Sharad , for multiple email addresses create via SO23 a distribution list. and assigned it the same way in the job.In recipient field instead of entering the email address you entered your ditribution list name.
Having an excel file is also pretty easy. The email received will contain an html file(this is normlly what is customized in SCOT ). Just open the htm file in excel and the conversion is automatic, nothing to be developped.
I have a requirement , I have a report which is scheduled in background.
I need the report out put to be transferred as excel attachment to the list of Mail Ids
Request you to guide me.
How to add custom email body while sending Background job spool to external email address?