My Oracle Support Banner

Cannot receive Email Notification for Job Status Change for a Multi-Task Job if the job owner is different to the User Subscribing to the Rule (Doc ID 1529719.1)

Last updated on MAY 09, 2021

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.2.0 to 12.1.0.2.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

In Cloud Control 12.1.0.2  a user who has subscribed to an incident rule is unable to receive job status change emails (eg. email to show that the job is scheduled, running etc.) for a multi-task job, if they are not the owner of the job that has run, and if the job owner has not chosen "email notification for owner", and if the job runs on different target types.  This behaviour differs to the behaviour of a single task job under the same circumstances, where the email about the job status change is received.

The following testcase demonstrates this:-

 

1)set up 2 super administrators, in this example, SYSMAN and ADMINTEST
(settings for these accounts can be viewed from setup/security/administrators)

SYSMAN is associated with a email address 1 (sysman@oracle.co.uk)
ADMINTEST is associated with a different email address (admintest@<DOMAIN_NAME>)

2) As the SYSMAN user go to setup/incidents/job events
view the "job event generation criteria"

step1: events for job status and targetless jobs
in section "enable events for job status" all possible statuses are ticked.

"Enable events for targetless jobs": Yes is ticked

Step2: Events for Targets
all hosts and databases which have been discovered have been added here.

3) Go to setup/incidents/incident rules

As the SYSMAN user, a test rule has been created called
"RuletoEmailaboutMultiTaskJobs"

Actions/view:

Job Name:%
Type: All Job Types
Owner: %

Click on the "Rules" tab:-
applies to "all job status change events"
action summary:email cc ADMINTEST
enabled:Yes

Notice that it is intended that SYSMAN will *not* receive an email about this
rule, to do this highlight rule and select Actions/email/unsubscribe me

4)Create a test job (a single task job)

Name:SingleTaskJob
target type:host
target:<pick a particular host>

Parameters tab:
command type: single operation
command:ls -ltr

Access Tab:
"This table contains adminstrators and roles that have access to this job":
(ADMINTEST and SYSMAN are listed)

E-Mail Notification for Owner

Only "scheduled" is ticked.

Scheduled is ticked to try and make the testcase clearer. This means that the owner of the job (in this case SYSMAN) has only chosen to receive a 'scheduled' status. However the second administrator 'ADMINTEST' which has subscribed to this rule, should receive all statuses (as defined in the rule definition).

5) Submit the single task job.

Check both the inbox associated with 'SYSMAN' account (eg. sysman@oracle.com) and the inbox associated with the ADMINTEST administrator account (admintest@oracle.com).

The SYSMAN account has received the scheduled email (as expected)
The ADMINTEST account has received emails about all statuses of the job.

6) Now create a multi-task job:-

in "Tasks" tab:-

Task1Multitask is an OS command that runs 'ls -ltr'
Task2Multitask is a sqlscript that runs on a database (on a different host)
on success of Task1Multitask. This job does a select * from dual;

in Access tab, the same settings are used as for the single task job.

7) The Multi task job is submitted.

8) The result is that both inboxes only receive the 'scheduled' status email.

9) Do a 'create like' on the multi-task job, this time tick all statuses for "email notification for owner" This time both email accounts will receive emails for every different status of the job. This is the inconsistent behaviour because the receiving of the emails should not be dependent on the owner of the job receiving the email. It should work the same way as the single task job.

 

 

Cause

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
Symptoms
Cause
Solution
References

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