Page History
...
- Required job variables include the
tovariable to specify the recipient of mail. - Any other variables are optional provided that a job resource is used that specifies connection details to your mail server, see below. Otherwise individual settings such as the SMTP host, SMTP port etc. can be specified from variables.
- Select the check box provided with each job variable if you want this variable to be added to the arguments of the mail job.
...
- from individual variables as offered by the job wizard.
- by use of a job resourceresources.
Use of Job Resource for Mail Settings
A number of settings for sending mail most probably carry the same values when used for a number of mail jobs. This includes e.g. the SMTP host, SMTP port etc.
...
- The variable names specified are selected to match use with the JITL
MailJobtemplate. - Consider the use of variable names that start with
mail.smtp.- These variable names correspond to Java properties available with the JavaMail API. Any of the JavaMail properties can be specified.
- Find a full list of available
mail.smtp.properties from https://javaee.github.io/javamail/docs/api/com/sun/mail/smtp/package-summary.html - Required properties include (but are not limited to):
mail.smtp.hostmail.smtp.port
...
| Name | Required | Default Value | Purpose |
|---|---|---|---|
commandto | yes | Carries the SQL statements. | |
| no | ./config/hibernate.cfg.xml | Specifies the configuration file (XML) format for Hibernate connections, see JS7 - Database. By default Agents ship without hibernate configuration files, however, if a file with the default name is available then it will be applied. |
| no | Raises a warning if the SQL statement creates a result set. |
| no | If stored procedures are called that return a result set then this argument has to be set to |
| no | Specifies how a result set is forwarded to order variables for subsequent jobs:
|
Explanation:
...
- Some DBMS might require and additional newline character.
- For example
update MY_TABLE set a='foo' where b='bar'; commit;
| list of mail recipient's e-mail address, multiple e-mail addresses are separated by comma | |||
| no | e-mail address used for sending mail | |
| no | the free-text name of the account that sends mail | |
| no | if no replies should be accepted then typically use an e-mail address such as | |
| no | e-mail address of carbon copy recipient, multiple e-mail addresses are separated by comma | |
bcc | no | e-mail address of blind carbon copy recipient, multiple e-mail addresses are separated by comma | |
subject | yes | the mail subject, consider to use ASCII 7bit characters | |
body | yes | the mail body specified as plain text or HTML depending on the content_type setting | |
content_type | no | text/plain | a content type text/plain specifies plain text mail, a content type text/html specifies use of HTML mails. |
encoding | no | 7bit | the character encoding of subject and body, by default ASCII 7bit is used |
charset | no | iso-8859-1 | by default Latin 1 (iso-8859-1) is used |
attachment | no | the path to a file to be attached, multiple files are separated by comma | |
attachment_content_type | no | application/octet-stream | the attachment content-type typically allows binary files |
attachment_encoding | no | Base64 | any attached files are encoded with printable base64 characters |
attachment_charset | no | iso-8859-1 | by default Latin 1 (iso-8859-1) is used |
mail.smtp.host | yes | the hostname or IP address of the SMTP server | |
mail.smtp.port | no | 25 | the port of the SMTP server |
mail.smtp.user | no | the user account to be used in case that the SMTP server requires authentication | |
mail.smtp.password | no | the password to be used in case that the SMTP server requires authentication | |
mail.smtp. ... | no | any additional Java properties can be used as applicable to the JavaMail package |
...
Further information
- Job Documentation:
...
Overview
Content Tools