Using Scheduled Database Tasks - IFS Enterprise Explorer

[Using IFS Enterprise Explorer Clients] [Administration in Enterprise Explorer] [To Administration in Enterprise Explorer]

Explanation

Scheduled Tasks help you to view and administrate the scheduling of system tasks.

There are following categories of tasks can be scheduled.

• Database tasks
• Reports
• Task Chains

In the context, the term task refers to all these categories. A task is scheduled to execute at a predefined date and time depending on the selected execution plan. A task can be configured to execute repeatedly with in a defined period. If desired, the task can be run as a background job as soon as possible, overriding the execution plan set for it.

Figure 1. Scheduled Tasks in the Navigator

Prerequisites

N/A

System Effects

N/A

Window

New Database Task Schedule , Scheduled Database Tasks 

Related Window Descriptions

Create New Database Task Schedule, Scheduled Database Tasks

Procedure

• Create New Task Schedule
• Create New Database Task Schedule
• Enter Schedule
• Enter Parameters
• Enter Advanced Settings

Create New Task Schedule

This is used to schedule both Database tasks and Report tasks. The number of steps depend on the task type and the selected individual task.

Create New Database Task Schedule

Figure 1: The scheduling page

Enter Schedule:

Enter the desired name in the Schedule Name field. The default value is the selected task name.

There are several execution plans from which you can choose.

• Daily - The task is scheduled to be executed every day at a particular time.
• Weekly - The task is scheduled to be executed at a particular time on the selected day(s) of the week.
• Monthly - The task is scheduled to be executed at a particular time on the particular day of the month.
• Scheduled - The task is scheduled to be executed on a particular day at a particular time.
• Interval - The task is scheduled to be executed every hour and minute specified.
• Custom - The task is executed depending on the given custom expression. The custom expression must return a date (ex: SYSDATE + 1/3600). Oracle Scheduler syntax is allowed (i.e. FREQ=WEEKLY; INTERVAL=2; BYDAY=FRI;). More details and examples can be found in the Oracle documentation under "Using the Scheduler Calendaring Syntax".

Enter Parameters:

Enter the task parameters for this task in the Parameters section of the window. The GUI for this step can be customized for each task. if a customized Task parameter sheet is not available then the default one is shown. Note that this is a dynamic step. For tasks that do not have parameters that can be set, this step is not available.

The default values for each parameter will be loaded when the GUI is dynamically changed.

Enter Advanced Settings:

In this step you can select the language in which you want the task to be executed, and the Start and stop dates for the schedule.

Active/Inactive

To make the task active or inactive check or clear the check box named Active. (Only active schedules are executed)

Viewing Background Jobs

The background jobs that ran for the task can be viewed by clicking this link. Note that this is disabled while you are creating a new task schedule, and is only enabled once the task is saved.

Figure 2: View background jobs for a task.

Clicking this link takes you to the Background Jobs feature if you have the required permissions. Otherwise, the link takes you to the Deferred Jobs Application Forms page.