Skip to Main Content
  • Questions

  • When does the report subscribed to mail runs

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Raghunadhan.

Asked: December 01, 2020 - 9:47 am UTC

Last updated: December 09, 2020 - 8:06 am UTC

Version: 5.2.2

Viewed 1000+ times

You Asked

I have subscribed interactive report to mail when does the report sent in mail that is at what time report receives to mail if i configure the report period as between 1-dec 2020 1000 :AM to 1-jan-2021 at what time the reports receives.

2.How to subscribes report for first Monday of each month . Can you please help on this.

and Connor said...

This is controlled by a background job which takes care of the work. You can check the scheduler to make sure its working

SQL> select job_name, enabled, state, last_start_date
  2  from all_scheduler_jobs
  3  where job_name = 'ORACLE_APEX_WS_NOTIFICATIONS';


JOB_NAME                       ENABL STATE                LAST_START_DATE
------------------------------ ----- -------------------- ----------------------------------------
ORACLE_APEX_WS_NOTIFICATIONS   TRUE  SCHEDULED            09-DEC-20 03.30.00.476000 PM +08:00



SQL> select status, actual_start_date, errors
  2  from all_scheduler_job_run_details
  3  where job_name = 'ORACLE_APEX_WS_NOTIFICATIONS'
  4  order by log_id desc;

STATUS                         ACTUAL_START_DATE                                    ERRORS
------------------------------ ---------------------------------------------------  ------------
SUCCEEDED                      09-DEC-20 03.30.00.476000 PM +08:00
SUCCEEDED                      09-DEC-20 03.00.00.286000 PM +08:00
SUCCEEDED                      09-DEC-20 02.30.01.088000 PM +08:00
SUCCEEDED                      09-DEC-20 02.00.00.905000 PM +08:00
SUCCEEDED                      09-DEC-20 01.30.00.888000 PM +08:00
SUCCEEDED                      09-DEC-20 01.00.00.770000 PM +08:00
...
...


So your report will be delivered at *approximately* the time you requested. I don't think you can do "first Monday" - the best you can do with "first day" of month.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, December 09, 2020 - 10:53 am UTC

Ok.I want to schedule at 2nd of the month but since it is past will it work
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.