How do I ask a question on the forums?
post contains NOTHING of substance to guess at possible problem.
is COPY & PASTE broken for you?
Thanks sol.beach, you seem to be really tactful and considerate.
Not sure what you want me to copy and paste. My whole dba_scheduler_job_run_details showing that the alerts I am talking about are not there? The "set_attribute" command I ran last week that I don't have a record of anymore?
Does DBA_SCHEDULER_JOB_LOG have any useful details in it?
Hi Dan, just like the dba_scheduler_job_run_details table, dba_scheduler_job_log also doesn't have a record of the early/wrong alerts being sent.
1 person found this helpful
The set_attribute actions are not logged. Unless you change the purging policy of log entries, you should see your jobs if they ran. If you don't see your jobs in the dba_scheduler_job_run_details, it means they didn't run at all.
Thanks GregV. I wasn't expecting to see the set_attribute command stored on those tables, I just mentioned that because it was the last change we made on the jobs.
But I guess by the answers I'm getting it shouldn't impact this at all, and that was my top concern. I'm still not sure how these emails were sent, but it seems they weren't fired from the scheduler.
Even if your change had impacted the job's schedule, there would have been rows in the DBA_SCHEDULER_JOB_RUN_DETAILs view to show that they ran. If not, then the alerts have probably sent through the underlying procedure.
Try your luck in checking V$SQL:
select * from v$sql where upper(sql_text) like '%UTL_SMTP%';