Mail Trigger

[knaveennavi]

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

what should i do?

or

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

[jmodaal]

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

[knaveennavi]

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.

[jmodaal]

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?

[FredericGirod]

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/

[knaveennavi]

Hi Frederic ,

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

[RaymondGiuseppi]

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.