My Oracle Support Banner

E-PRCS: Master Note for SMTP Process Scheduler (Doc ID 1164983.1)

Last updated on DECEMBER 09, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.44 and later
Information in this document applies to any platform.
** Reviewed Currency on 6th April, 2016**

Details


SMTPTrace=0 <------ Turns SMTP trace on/off. Trace shows up in the APPSRV.LOG file.
SMTPSendTime=0 <------ This parameter, if enabled, controls whether the message contains a "send time" populated by the application server.
If disabled, the "send time" is blank and will be populated by the receiving gateway (depending on the gateway).
To enable this option enter 1; to disable enter 0.
This puts the time that the email was Sent on the email itself.
This setting is not available in the PSPRCS.CFG file.

Additional parameters are found in Tools 8.4x, they are as follows:

SMTPBlackberryReplyTo= <------ The internet address that you want to be the "Reply To" address for Blackberry Email Responses.
This must be a valid address such as <EMAILID>@<FQ_HOSTNAME>

Chekpoints

1. Verify if the mail server is accessible by connecting via telnet from the Process Scheduler server.
2. Correct SMTP server details are configured for both the Application Server as well as the Process Scheduler.
3. Send e-mail from PSMAIL from command line and see if that works.
4. Send e-mail notification for a standard delivered process through Process Scheduler.
5. Turn on SMTP Trace then replicate the problem and collect the complete set of log files and the generated trace file.

If mail server is not accessible, make sure the mail server is properly configured.
Once it is accessible, then go to point #2 below. 

 

There is nothing much to do with reference to the Process Scheduler, if we get SMTP errors, other than providing the correct SMTP server details in the configuration file.

Steps
-------
1. Open configuration files (psappsrv.cfg and psprcs.cfg) and make sure to configure SMTP server settings accurately for the below parameters :

See SMTP PeopleTools 8.1x, 8.4x Configuration.
Use the fully qualified domain name .

2. Save the files.

3. Clear CACHE files and reconfigure the servers for changes to take into effect.

Note:
Make sure SMTP settings are configured for both the Application Server as well as the Process Scheduler.

 

Below describe how PSMAIL works and its syntax.

PSMAIL.EXE looks for the environment variable PS_SERVER_CFG to retrieve its SMTP Settings.
That variable is usually set on the Application Server and Process Scheduler on boot up.
On the Application Server, it usually is set to %PS_HOME%\appserv\\psappsrv.cfg.
On Process Scheduler, it usually points to %PS_HOME%\appserv\prcs\\psprcs.cfg.

The possible command line arguments are:
TO = the recipients of the email
CC = carbon copy list of recipients
BCC = blind carbon copy list of recipients
FROM = the sender of the email
SUBJECT = the subject heading of the email
BODY = the email body
FILE = list of file attachments to send with email.
File location is relative to where PSMAIL.EXE is run from.
INPUT=points to a config file that contains the above seven arguments.
This was to bypass the maximum number of characters allowable on a command line and carriage return/line feeds.

The tokens - or / can be used in front of the above arguments.
The values for each argument must be encapsulated in double quotes.
Look at the following examples.

Sample usage:
PSMAIL -TO <EMAILID>@<FQ_HOSTNAME> -FROM<EMAILID>@<FQ_HOSTNAME> -SUBJECT"Daily Inventory Report(s)"
PSMAIL /TO<EMAILID>@<FQ_HOSTNAME> /FROM <EMAILID>@<FQ_HOSTNAME> /SUBJECT"Time Out Reporting" /BODY"Please report any PTO for the month of March."
PSMAIL /INPUT"demo1.txt"

The content of the file, "demo1.txt" is as below:

-TO<EMAILID>@<FQ_HOSTNAME> -FROM<EMAILID>@<FQ_HOSTNAME> -SUBJECT"System Test Daily Inventory Report(s)" -BODY"Here is the report(s) you requested. (Both A & B Databases)" -FILE <DIRPATH>.out

If you are using -INPUT or /INPUT then you need to have the input file in UNICODE format.
(On NT, you can do this by saving the file in notepad as "unicode format" & on Unix you can run the following PeopleSoft binary file:
PSUNICONV ASCII UCS-2 )

Try the below and see notifications are received:

4.1. Login into the application using PS/VP1 user.
4.2. Navigate to PIA > PeopleTools > Process Scheduler > Processes and Open the process you need to set notification (AEMINITEST).
4.3. Navigate to Notification Tab, You can select Your User ID and select the Box for ON success.
Note :
You can also select the Role instead of User and also check the box ON Error and ON Warning if needed.
4.4. Add email address to your User ID following the below steps:
4.4.1. Navigate to PIA > PeopleTools > Security > User Profiles and Open you User ID.
4.4.2. Click on Edit Email Addresses link and make sure your email address is correctly added.
4.6. See if any notification is sent.

See How to turn on SMTP tracing.


FAQ

1. How to turn on SMTP Tracing?
2. How to turn-off notifications on JobSets, PSJobs, or processes that have notification enabled?


As of PeopleTools 8.44 a SMTP trace option was added to the Process Scheduler configuration file to enable SMTP tracing for e-mail problems.

To enable SMTP trace, launch the PSADMIN utility to administer the Process Scheduler server domain and choose the option to "Configure a domain".

The two key settings are:
LogFence=5
SMTPtrace=1

Make these changes and reboot the Process Scheduler domain and clear CACHE so that these changes come into the effect.

Then replicate the problem and collect the complete set of log files under $PS_HOME/appserv/prcs/DBNAME/LOGS directory.

The notification page settings are stored in table:
PS_PRCSDEFNNOTIFY

To turn-off notification, the following steps can be followed:


1. Identify which JobSets, PSJobs, or processes have notification enabled, query the following tables.


For JobSets:
SELECT * FROM PS_SCHDLNOTIFY

For PSJobs:
SELECT * FROM PS_PRCSJOBNOTIFY

For Processes:
SELECT * FROM PS_PRCSDEFNNOTIFY

2. Using the results of the queries above, turn-off notification of each definition through PIA, or simply update the tables through SQL.

Even if it may be tedious to turn-off notifications on each definition through PIA, this is the recommended way.
If you plan to turn off the notification through PIA, remove the row of notification with the minus sign (-).
That will ensure the notification set being removed from the tables completely.

To access the notification page of each definition through PIA, navigate to:
PeopleTools > Process Scheduler > Schedule JobSets
PeopleTools > Process Scheduler > Jobs
PeopleTools > Process Scheduler > Processes

To update the definition through SQL, simply remove the rows from the following tables:
PS_SCHDLNOTIFY
PS_PRCSJOBNOTIFY
PS_PRCSDEFNNOTIFY

 

Note:
Once all the definitions have been updated, CACHE on the process scheduler needs to be cleared and process scheduler to be re-booted for the changes to take into effect.

Reference

Process Notifications
PeopleBooks > Enterprise PeopleTools 8.4x PeopleBook: PeopleSoft Process Scheduler > Defining PeopleSoft Process Scheduler Support Information

Defining Job Notifications
PeopleBooks > Enterprise PeopleTools 8.4x PeopleBook: PeopleSoft Process Scheduler > Defining Jobs and JobSets

Server Notifications
PeopleBooks > Enterprise PeopleTools 8.4x PeopleBook: PeopleSoft Process Scheduler > Setting Server Definitions

KEYWORDS:

PROCESS SCHEDULER, SCHEDULER, SMTP, EMAIL, E-MAIL, NOTIFICATION, WMAIL NOTIFICATION, SMTP SERVER

 

Actions

 

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
Actions
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.