How to Schedule a Job

Job scheduling is a powerful way to automate repetitive tasks, but it can often become complex and difficult to manage. We've designed our scheduler to be simple and intuitive, making automation accessible without the complexity.

Creating a Scheduled Job

To create a new scheduled job, configure the following settings in the Scheduler section:

Recurrence

• Disable: Turns off the scheduler for this job (can also be used to pause an existing scheduled job)
• One-time: Executes the job only once at the specified start date, no new job is created (acts as a delayed execution)
• Daily: Runs and creates a new job every day
• Weekly: Runs and creates a new job every week on the same day
• Monthly: Runs and creates a new job every month on the same date

Start Date

• Specifies when the scheduled job should begin executing. The job will start based on your selected recurrence pattern from this date.

End Date

• No end date: The job will run indefinitely according to the recurrence pattern
• With end date: The job will automatically pause after the final execution within the end date range

Immediate Execution

After submitting a scheduled job, you can use the Run Now option to:

• Execute the job immediately for testing purposes
• Run the job on demand, outside the regular schedule

This feature is especially useful for testing new scheduled jobs or manually running jobs when needed.

Statuses

Status	Description
SCHEDULED	The job has been submitted into the scheduler queue.
SCHEDULED (PAUSED)	The job has reached the end of the recurrence period.
SCHEDULED (ERROR)	The job has invalid settings (see below).

Paused Status

A scheduled job enters SCHEDULED (PAUSED) in the following cases:

• End date reached: The job completes its final execution within the specified end date range
• Invalid date range: The start date is in the past, and the end date occurs before the next recurrence. For example: Start date is January 1 with weekly recurrence, but end date is January 3 (before the next weekly execution)

Error Status

When a scheduled job displays an error status, you can find details on the job’s detail page. The most common errors are related to the connection associated with the job:

1. Verify that the connection is VALID
2. Check the connection URL and/or credentials
3. Ensure the connection has not been deleted
4. Confirm that the Oracle version is supported
5. Rerun the connection for validation

Once the connection issue is resolved, the job will automatically return to SCHEDULED or SCHEDULED (PAUSED) status.

Find Scheduled Jobs

For convenience, scheduled jobs appear in the same data table as other jobs. To easily locate scheduled jobs, filter by the Scheduled status in the data table status column:

Find the Next Run Date

In the data table, you can unhide the Scheduled At column to view, filter, or sort jobs by their scheduled time.

Additionally, the next run date is also available on the job’s Details page.

Best Practices

1. Test your jobs: Use Run Now to verify job configuration before relying on scheduled execution
2. Monitor connections: Regularly ensure server connections remain valid
3. Set realistic schedules: Allow sufficient time between executions for job completion
4. Use end dates strategically: Apply end dates for temporary or time-bound jobs

Troubleshooting

Please contact our support team and provide the job ID found on the Details page.