Scheduling Jobs/Tasks

In order to schedule jobs/tasks using the Job Scheduler, you must first add one or more computers (reference to applications servers) which will be used to run Micromine Geobank to carry out the tasks. This can be your machine or another server. To add computers to your Job Scheduler, follow the procedure outlined in Adding a Computer (Reference to an Application Server).

A job/task in Micromine Geobank is a process or procedure which performs a specific function - such as running a report or maintaining a database. The available Micromine Geobank tasks of the supported types can be scheduled to run unattended on configured computers using the Job Scheduler.

Note: details of unattended jobs performed by Micromine Geobank are written to the log file to assist in diagnosing any issues.

In the Configuration Manager, select User Interface | Automation | Job Scheduler to open the Job Scheduler.

  1. Click the The New button for the Computers panel on the Job Scheduler formNew button in the Job List panel at the right. The tabs below the Job List are enabled.

Job

  1. Enter an identifying name for the task in the Name field.

  2. Enter a description of the scheduled job in the Description field.

The user credentials under which the job is to be performed must be entered in the provided User and Password fields.

Tip: Enter the password as the last item before selecting the green tick to save your changes, because the password clears when other edits are made. This is for security reasons: The password is passed directly to the application server's Windows Task Scheduler to authorise the change, it is not stored in the database at Job level.

  1. To select a user from the network, click the Select User button. The Select User dialog opens.

The Select User dialog opened from the Job Scheduler

  • Enter the user name in the field provided.

  • Click Check Names to verify the name entered.

  • Click OK to add the User field in the Job tab.

  1. Enter the password for the selected user account in the Password field (this will need to be re-entered if more changes are made).

The Job tab on the Job Scheduler form

Trigger

The Trigger tab is used to configure the settings for when and how often the scheduled job should occur.

There are several settings available, and the subsequent options are dynamically displayed according to selection. Detailed information on the settings is contained in Trigger.

  1. Select the relevant radio button to configure the trigger options.
    For example, to configure a database backup every week, select Weekly.

  2. Set the schedule using the options provided at the right. These options will differ according to the chosen setting.
    For example, for a Daily schedule, set the Start Date and Time and enter 1 for the Recur every _ days setting (e.g. today at 5:30:00 PM).

The Trigger tab with the Daily option selected

Advanced settings

The Advanced settings options on the Trigger tab enable the further configuration of the schedule, including delay and expiration values. Information on the settings is contained in Advanced settings.

Action

The Action tab is used to configure the task to be scheduled and any relevant parameter values. Information on the options in the Action tab is contained in Action.

The Profile drop-down is used to select the user profile (as configured in Micromine Geobank Profiles) under which the task to be scheduled is enabled. If you don't know which profile your required task is categorised under, you can search for it by name using the Search button.

Note: Only tasks added to the Profile/s for the User can be added to the schedule. If the user does not have the necessary task added to a Profile to which they are assigned, it will not be completed successfully.

To select the task to be scheduled,

  1. Select the relevant Profile from the drop-down list.

The Task List drop-down allows you to select a category under which the task to be scheduled is contained.

  1. Select the required task list from the drop-down.

Finally,

  1. Use the Task drop-down to select the task to be scheduled.

The TaskID field is automatically filled with the ID for the task selected in the Task drop-down.

In some cases, the scheduled Task may need further configuration. This is achieved using the Set Substitution Parameters option. Where a task selected for a schedule does not require any further configuration, the Set Substitution Parameters option will not be enabled.

To set the parameters for a task,

  1. Click the Set Substitution Parameters button.

    A form is opened, relevant to the scheduled task.

The Substitution Parameters form

The available fields in the form will vary according to the task you have selected for scheduling., In the example above, the Hub for filtering data and the required Keys from the selected Hub must be configured. To use the fields in any Substitution Parameter form,

  1. Click the ellipsis in a field to open the selection form.

The selection form for the Database parameter

  1. Select the required item from the list.

  2. Click OK to add the selected item to the form.

The item selected will in most instances determine the available items in subsequent fields. For example the Hub selected above provides a set of Keys from which to choose:

With the parameters selected,

  1. Click OK in the Substitution Parameters form.

    The configured parameters are displayed in the Parameter Values grid at the bottom of the Action tab.

The Action tab with the Parameter Values displayed

With the job schedule configured as required,

  1. Click Save at the top right of the Job List.

The details of the task schedule are saved and the job will be run on the configured computer at the specified time.

Events that occur for the schedule, such as when the scheduled task is registered, the next run time and last run time, and the category of the event are all collected in the event log for the Job Scheduler, displayed in the History tab.

The History tab of the Job Scheduler

For information on any issues that may arise, see Troubleshooting.

Job Scheduler