Skip to Content
Author's profile photo Martin English

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.

Transaction SM37 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.

Transaction SM37 Spool list Recipient

 

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.

Troubleshooting

 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.

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Hi martin
      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.
      Muthu

      Author's profile photo Martin English
      Martin English
      Blog Post Author
      Hi Muthu,
      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.

      Author's profile photo Martin English
      Martin English
      Blog Post Author
      Sorry - I haven't worked out how to edit replies 🙂

      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 🙂

      Author's profile photo Former Member
      Former Member
      Hi

      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.
      Muthu

      Author's profile photo Former Member
      Former Member
      Hi

      I have cancelled the job but i could not see entry in SOST itself. Why?
      --
      spl question.
      PS:-Do you know what are the events are pushed to SOST/ i am interested to find out those.

      br
      Muthu

      Author's profile photo Former Member
      Former Member
      Thanks Martin. I could see in SOST. Great. Appreciate good work.

      Muthu

      Author's profile photo Former Member
      Former Member

      SM37 cannot sent the email accordingly.

      I could not see the records in SOST.

      Author's profile photo Carlos Eduardo Oliveira
      Carlos Eduardo Oliveira

      Hi Martin,

      I have setup a job in SM36 with "Spool List Recipient" containing my yahoo email (below).

      PIC.gif

      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.

      Spooler.gif

      Then if I change the "Time of Print" to "X Print out Immediately", I get the error below.

      ERROR MESSAGE.gif

      Do you know what this issue could be?

      Anything would help.

      P.S. I dont see anything in SOST

      Thx

      Carlos

      Author's profile photo Ning Li
      Ning Li

      amazing!

      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?

      Best regards,

      Author's profile photo Sharad Patel
      Sharad Patel

      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.

      Thanks

      Sharad

      Author's profile photo Former Member
      Former Member

      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.

      Author's profile photo Former Member
      Former Member

      HI,

      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.

       

      Author's profile photo Prabhakar reddy Gade
      Prabhakar reddy Gade

      How to add custom email body while sending Background job spool to external email address?