SendEmail Script Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
This page contains script examples for the [[ | This page contains script examples for the [[SQL Scripting Commands#--.23SendEmail|SendEmail]] script command. | ||
The following example will send an e-mail message with two attachments to multiple recipients. | The following example will send an e-mail message with two attachments to multiple recipients. | ||
Latest revision as of 20:50, 25 October 2021
This page contains script examples for the SendEmail script command.
The following example will send an e-mail message with two attachments to multiple recipients.
(SELECT 'EmailFrom', 'example.from@address.com') UNION ALL (SELECT 'EmailTo', 'recipient.one@address.com,recipient.two@address.com,recipient.three@address.com') UNION ALL (SELECT 'EmailSubject', 'Example E-mail') UNION ALL (SELECT 'EmailBody', 'QPR ProcessAnalyzer example script started running.') UNION ALL (SELECT ''EmailAttachmentQuery', 'SELECT * from #EmailAttachmentParameters') UNION ALL (SELECT 'SmtpServer', 'localhost') --#SendEmail
Where the #EmailAttachmentParameters table contains following data:
| Name | Content | Media type | Creation time |
|---|---|---|---|
| Example attachment picture | Picture.jpg | image/jpg | 2016-04-22 12:00:00 |
| Example attachment xml file | Example.xml | text/xml | 2016-04-22 12:00:01 |