topic Re: Mail Trigger in Application Development and Automation Discussions

Mail Trigger

knaveennavi — Thu, 03 Feb 2022 09:09:48 GMT

i want trigger a mail to the mail id which is exists on sm36 job scheduling recipients mail id.

what should i do?

how do i get a job scheduling recipient mail id in report program?

Re: Mail Trigger

jmodaal — Thu, 03 Feb 2022 09:26:50 GMT

Hello,

the email address for the job is in table TBTCCNTXT, field CTXTEXT (first letter is the language for the email, followed by a semicolon and the email address).

Re: Mail Trigger

knaveennavi — Thu, 03 Feb 2022 09:43:04 GMT

Hi Jan,

I checked that table no values found.

actually i did mail trigger program it works.

but my requirement is mail trigger to the mail id which avaliable in SM36 Recipient mail id.

so now i want that receipent mail id into my mail trigger program.

how do i get that mail id into my report program.

Re: Mail Trigger

FredericGirod — Thu, 03 Feb 2022 10:16:46 GMT

if you just want to send the result of a job to people by mail, you don't need program :

https://blogs.sap.com/2010/02/25/how-to-email-output-from-background-jobs/

Re: Mail Trigger

jmodaal — Thu, 03 Feb 2022 11:07:38 GMT

Hello,

hmm, if I schedule a job in SM36 and enter the e-mail address in the "E-Mail notification" dialog, it appears in the given table. Picture attached. I would be astonished if this is not the usual behaviour.

Or is it about the data in the "Spool List Recipient" dialog?

Re: Mail Trigger

knaveennavi — Thu, 03 Feb 2022 11:15:53 GMT

Hi Frederic ,

You're correct .but i want my result as a Excel format

Re: Mail Trigger

RaymondGiuseppi — Thu, 03 Feb 2022 14:48:03 GMT

If you are asking on 'E-mail notification'

Call FM BP_JOBCONTEXT_SELECT_BY_JOB or browse view TBTCJCNTXT (TBTCCNTXT join TBTCO)

If you are asking on 'Spool List Recipient'

Look at question FM to read the spool list recipient maintianed in SM36 or browse tables TBTCO, SOID, SODM, SOUD, etc.