Scheduler

Introduction

Once a Package, Transformation, or SQL Script is created, the Scheduler enables the user to execute it at regular intervals. It can be set to run once, or on a daily, weekly, or monthly basis. Additionally, the user can specify a particular day of the week or month for execution.

Action Descriptions

Schedule Properties
Configure and manage scheduling options for executing actions.
Refresh Data Grid
Reload the displayed data to ensure the grid reflects the most recent updates.
Create a New Record
Add a new entry to the data source.
Post Changes to the Database
Save and apply any modifications made to the records in the database.
Delete Record
Remove the selected record from the data source.
Clone Record
Duplicate the selected record, creating an identical copy.
Print
Send the current view or selected data to a printer.
Print Preview
Display a preview of the data as it will appear when printed.
Find
Search for specific data or records within the grid.
Export Data
Save the displayed data to an external file in various formats.
Export Data into Excel
Export the data directly to an Excel file for further analysis.
Show/Hide Fields
Customize the visible columns in the data grid by showing or hiding specific fields.
Auto Format Grid
Automatically apply formatting to the grid for a cleaner and more organized appearance.
Show Grouping Panel
Display a panel that allows grouping of data by specific fields.
Edit Selected Object
Open the selected object for modification.
Run Selected Object Right Now
Execute the selected object immediately, bypassing the schedule.

Options

Note: The timeout is in hh:mm:ss format

The Advanced Schedule Options feature enables the definition of execution boundaries, allowing precise control over when actions are permitted to run. This ensures that scheduled tasks operate within specific time frames or conditions.

The user may specify the day of the week when to execute the batch. The user must specify at least one day of the week. The user may specify the day of the week when to execute the batch. The user must specify at least one day of the week.