I´ve created a job on a schema called "dbsgestaodocumentos" (using SYS with sysdba privs) and enabled it to send email notifications, the job runs as its supposed to and no email is sent.
Then, as a test, I created the same job on SYSTEM schema, enabling email notifications as well and I received the email right away.
so by running this query I can see what was processed and what wasn´t:
select queue,
msg_state,
enq_time,
enq_user_id,
deq_time,
deq_user_id,
t.user_data.event_type,
t.user_data.object_owner,
t.user_data.object_name,
t.user_data.event_timestamp
from sys.AQ$SCHEDULER$_EVENT_QTAB t;
AQ$_SCHEDULER$_EVENT_QTAB_E EXPIRED 04/03/15 SYS JOB_STARTED DBSGESTAODOCUMENTOS VERIFICA_PARM_DISTRIBUICAO 04/03/15 06:18:47,778792000 AMERICA/SAO_PAULO
AQ$_SCHEDULER$_EVENT_QTAB_E EXPIRED 04/03/15 SYS SYS JOB_SUCCEEDED DBSGESTAODOCUMENTOS VERIFICA_PARM_DISTRIBUICAO 04/03/15 06:18:50,736969000 AMERICA/SAO_PAULO
SCHEDULER$_EVENT_QUEUE PROCESSED 04/03/15 SYS JOB_FAILED SYS TESTE 04/03/15 07:41:22,228279000 AMERICA/SAO_PAULO
SCHEDULER$_EVENT_QUEUE PROCESSED 04/03/15 JOB_STARTED SYS TESTE 04/03/15 07:41:21,982241000 AMERICA/SAO_PAULO
I noticed that the queue on the job owned by sys is different than the one owned by DBSGESTAODOCUMENTOS but I don´t know if it working or not has to do with it.
Maybe some grant to DBSGESTAODOCUMENTOS is missing to be able to send emails from scheduler, I don´t know.
And as a last information, when I create a job/enable notifications with the owner of the schema, the email arrives. But I should be able to create as SYS on other schemas and the notif. email should arrive.
Thanks!!