Mail Automation in Oracle Apex

Step1: Open Oracle Apex Application



Step2: Go to Shared Component




Step3: Click on Automation




Step4: Configure Automation

·       Click on create 



·       Give name and other mandatory details

·       Give type -Schedule

                 -On Demand

·       Mention action initiated on -Query

                                      -Always

·       Schedule your execution-Every 15 min

                                              -On the Hour

                                              -Daily at mid night

                                              -Custom

·       Click on next

·       

1. Name

  • Defines the name of the automation.
  • Helps identify the automation within the application.

Example: Asset Return Reminder Automation

2. Currently Executing

  • Indicates whether the automation is currently running.
  • Values:
    • Yes – Automation is executing.
    • No – Automation is idle.

3. Type

The automation can be triggered in different ways:

On Demand
  • Runs only when manually executed.
  • Useful for testing or user-triggered processes.
Scheduled
  • Runs automatically based on a schedule expression.
  • In the screenshot, the Scheduled option is selected.

Schedule Expression

Defines when the automation should execute.

Example from the screen:

FREQ=HOURLY;INTERVAL=1;BYMINUTE=0

Meaning:

  • Run every hour.
  • Execute at minute 0 of each hour.
  • Example: 1:00 PM, 2:00 PM, 3:00 PM, etc.

5. Schedule Status

Controls whether the automation is active.

  • Active – Automation runs according to the schedule.
  • Disabled – Automation will not run.

The screenshot shows Disabled, meaning the automation is currently turned off.

6. Actions Initiated On

Determines how the automation identifies records to process.

Options include:

Query
  • Processes rows returned by a SQL query.
  • Most commonly used option.
Function Body Returning Boolean
  • Runs based on a PL/SQL function that returns TRUE or FALSE.
Always
  • Executes every time the automation is triggered regardless of conditions.

Source Section

The source specifies where the automation gets its data.

In the screenshot:

  • Data Source: Local Database

This means the automation retrieves data from tables or queries within the application's database.

·       Click on next



Step 5: We will get that screen  Once Configure Automation

We can configure -Setting

                             -Source

                             -Action

                             -Action Execution

                             -Additional code execution

                             -Server-side code exaction







 

 

Comments

Popular posts from this blog

Implementing Authentication and Authorization in Oracle APEX

Mastering Shared Components in Oracle APEX

Designing a Scalable Database Architecture for Oracle APEX Applications