Tools → Scheduler

About the Scheduler

The Scheduler allows you to both manage the scheduled jobs for dashboard delivery and create and manage scheduled jobs for physical schema loads, data notifications, and schema notifications.

Incorta sends the scheduled dashboards, data notifications (dashboard alerts), or schema notifications in an email to the recipients you specify. You can also deliver a dashboard to a Data Destination.

Important: Etc/GMT time zones

When you select a time zone for scheduled jobs, note that Etc/GMT time zones have the opposite offset of similar GMT time zones. In other words, the Etc/GMT+x is the opposite of the GMT+x:00; however, the Etc/GMT+x is the same as the GMT-x:00. For example, if the UTC time is 12:00pm, then the time in the Etc/GMT+4 and GMT-4:00 time zones will be 8:00am while the time in the Etc/GMT-4 and GMT+4:00 time zones will be 4:00pm.

Scheduler access rights

To access the Scheduler, in the Navigation bar, select Scheduler.

All Incorta Analytics users can access the Scheduler, but not all users can create or manage scheduled jobs. Only users who created or have edit rights to a dashboard can edit a scheduled job for a dashboard delivery. The users who create or have edit rights to a schema can create and manage a scheduled schema load.

Note

If you do not have edit rights and did not create a schema, the +New button is disabled.

Scheduler Anatomy

The Scheduler consists of the following:

Context Bar

The context bar consists of the four tabs:

  • Dashboards: contains a list of the scheduled dashboards deliverables
  • Schema Loads: contains a list of the scheduled schema loads
  • Data Notifications: contains a list of the configured data notifications (dashboard alerts)
  • Schema Notifications: contains a list of the configured schema notifications

Action Bar

The action bar consists of:

  • +New

The +New button opens the Add New menu, which varies from one tab to the other.

TabDescription
Schema LoadsAdd Schema Load - Select to add a new scheduled schema load job.

Data NotificationsCreate Notifications - Select to create a new dashboard notification.

Import Notifications - Select to import existing .zip data notifications file(s).

Schema NotificationsCreate Email Notifications - Select to create a new email notification upon a schema load success or fail.
Note

The +New button is not available in the Dashboards tab. You create a dashboard delivery scheduled job from the Content Manager.

The Search bar contains a search text box that is only available in the Schema Notifications tab. You can search for any part of a given job name.

The Search bar shows:

  • The number of items in the result list
  • The number of selected items in the result list with the option (x) to deselect the items
  • Delete icon, to delete all selected items
  • Export icon, to export Data Notifications (only available in the Data Notifications tab)

List View

Dashboards list view

The Dashboards list view displays all of the scheduled delivery jobs that you created for a certain dashboard.

PropertyControlDescription
Select Allcheck boxA header control to select all scheduled jobs for dashboard delivery.
NametextThe scheduled job unique name that you entered while creating the scheduled dashboard delivery.
OwnertextThe username that created the scheduled dashboard delivery.
DashboardlinkSelect the dashboard name to navigate to the corresponding dashboard.
StatuslinkThe status of the scheduled job. When selected, a prompt is displayed to confirm if you want to suspend/activate the scheduled delivery job.
A scheduled delivery status can be one of the following:

  ●  Active
  ●  Suspended
  ●  Completed (if it is scheduled for one-time delivery)
When you create a scheduled dashboard delivery, Status is Active by default.
Status filter (funnel icon)drop down menuA drop down menu that contains all possible statuses of a scheduled delivery. By default, the list is filtered by the Active status.
Use this drop down to filter the list with a certain status.
The drop down contains two buttons:
  ●  OK - to apply the filter
  ●  Reset - to clear any filtration applied
Next RuntextThe date, time, and time zone for when a scheduled job will run.
Delete (trash icon)buttonSelect to delete the scheduled delivery.
Note

When you select the name of a scheduled dashboard delivery, it opens the Schedule form, where you can edit the scheduled job details.

Schema Loads list view

The Schema Loads list view displays all scheduled schema load jobs that you created from the Scheduler or from the Schema tab.

PropertyControlDescription
Select Allcheck boxA header control to select all scheduled jobs for schema loads.
NametextThe scheduled job unique name that you entered while creating the scheduled schema load.
OwnertextThe username that created the scheduled schema load.
SchemalinkSelect the schema name to navigate to the schema for which the scheduled load job is created.
StatuslinkThe status of the scheduled job. Select to change the status of the scheduled load.
A scheduled schema load status can be one of the following:

  ●  Active
  ●  Suspended
  ●  Completed (if it is scheduled for a one-time load)
When you create a scheduled schema load, Status is Active by default.
Status filter (funnel icon)drop down menuA drop down menu that contains all possible statuses of a scheduled schema load. By default, the list is filtered by the Active status.
Use this drop down to filter the list with a certain status.
The drop down contains two buttons:

  ●  OK - to apply the filter
  ●  Reset - to clear any filtration applied
Next RuntextThe date, time, and time zone for when a scheduled schema load job is to run next.
Delete (trash icon)buttonSelect to delete the scheduled schema load.
Note

When you select the name of a scheduled schema load, it opens the Edit Schema Load form, where you can edit the scheduled schema load details.

Data Notifications list view

The Data Notifications list view displays all scheduled data alerts. With the Alert Editor, you can define a data alert. A data alert is a scheduled job that evaluates an alert condition. An alert condition is an Aggregated Table or a Listing Table insight that you create using the Analyzer. If the alert condition evaluates to True, the scheduled job for a data alert sends an email data notification to one or more users, one or more group of users, or one or more email addresses.

PropertyControlDescription
Select Allcheck boxA header control to select all scheduled data notifications.
NametextThe scheduled job unique name that you entered while creating the scheduled alert.
OwnertextThe username that created the scheduled data notifications.
TargetlinkSelect the dashboard name to navigate to the dashboard for which the scheduled alert is created.
StatuslinkThe status of the scheduled job. When you select it, a prompt is displayed to confirm if you want to change the status of the scheduled data notification.
A scheduled data notification status can be one of the following:

  ●  Active
  ●  Suspended
  ●  Completed (if it is scheduled for a one-time notification)
When you create a scheduled data notification, Status is Active by default.
Status filter (funnel icon)drop down menuA drop down menu that contains all possible statuses of a scheduled data notification. By default, the list is filtered by the Active status.
Select to filter the list with a certain status.
The drop down contains two buttons:

  ●  OK - to apply the filter
  ●  Reset - to clear any filtration applied
Next RuntextThe date, time, and time zone for when a scheduled data notification is to run next.
Delete (trash icon)buttonSelect to delete the scheduled data notification.
ExportbuttonSelect to export the selected data notification to a .zip file that you can use later on to import the scheduled data notification again.
Note

When you select the name of a scheduled data notification, it opens the Alert Editor form, where you can edit the data alert details.

Schema Notifications list view

The Schema Notifications list view displays all email alerts that you created for a schema.

PropertyControlDescription
Select Allcheck boxA header control to select all scheduled email notifications.
NametextThe scheduled notification unique name that you entered while creating the alert.
Schema(s)textSchema(s) name(s) for which you created the email alert.
Last ModifiedtextThe date and time for when the email notification was last modified.
Edit (pen icon)buttonSelect to edit the email notification.
Delete (trash icon)buttonSelect to delete the scheduled data notification.

Scheduler Actions

Using the Scheduler, you can perform the following actions:

Dashboard

Edit scheduled Dashboards

To schedule a dashboard for delivery, use the Content Manager. For more information, refer to Schedule Delivery of the Dashboard.

You can edit a scheduled dashboard delivery job through the Scheduler using the following steps:

  • Select a scheduled Dashboard job.
    • The Schedule: <dashboard-name> edit tool opens.
  • Edit the details of the scheduled job.
  • Select Save changes.

Schema Loads

Create scheduled Schema Loads

You can schedule a job to load a certain schema from the Schema Manager.

You can also create a scheduled job from the Scheduler by applying the following steps:

  • Open the Scheduler.

  • Go to the Schema Loads tab.

  • From the Action bar, select + New → Add Schema Load.

    The Add Schema Load form opens.

  • Fill in the following options in the form to schedule the Schema Load job.

PropertyControlDescription
Schema Load Nametext boxEnter a unique name for the Schema Load job you are creating.
Descriptiontext boxEnter a description for the Schema Load job.
Schemadrop down menuSelect the desired Schema to schedule a load job.
The list only displays the available schema(s) that you can edit.
Load Typedrop down menuSelect the type of the load you want to perform. The type of loads are:

  ●  Full
  ●  Incremental (default)
  ●  Staging
Recur Everyincrements and drop down menuSelect the recurrence of the load job by selecting an interval of minutes, hours, days, weeks, or months.
This option is disabled when you select the No recurrence checkbox.
No recurrencecheckboxSelect the checkbox to schedule the load job for one time only.
This option is unselected by default.
Attime and time zone selectionSelect the time and time zone desired to schedule the Schema Load job.
At → Nowbutton(Optional) Select Now in the time drop down menu to choose current local time.
At → OkbuttonSelect to confirm the time you chose.
BetweencheckboxSelect the checkbox to schedule the load job between a specific time start time and end time.
Betweentime and time zone selectionSelect the start time, end time, and time zone desired to schedule the Schema Load job.
Between → OkbuttonSelect to confirm the time you chose.
Everyincrements and drop down menuSelect the recurrence of the load job by selecting an interval of minutes or hours.
This option is only enabled when you select the Between checkbox.
From / OncalendarSelect the date range of the Schema Load job.
The field name changes to On when you select the No recurrence checkbox.
Does not endcheckboxSelect this check box to disable the end date of the load job.
Not available when you select the No recurrence checkbox.
AddbuttonSelect to save the form and add the scheduled job to the list.
CancelbuttonSelect to cancel what you have entered and close the form.
Note
  • In order to minimize the impact of Daylight Savings Time (DST) on job start time, ensure that any scheduled job you create runs at least once before DST occurs.
  • If you have a browser window open before DST occurs, you will need to refresh the browser page in order to view the correct Next Run time of a scheduled job after DST occurs.

Edit scheduled Schema Loads

You can edit a scheduled Schema Load through the Scheduler using the following steps:

  • In the Schema Loads tab, Select a scheduled Schema Load job.
    • The Edit Schema Load form opens.
  • Edit the details of the scheduled job.
  • Select Save.

Data Notifications

A data notification is an email notification for a data alert. From the Scheduler, you can define and edit the properties of a data alert using the Alert Editor.

Create a data notification

From the Scheduler, you can create and edit the properties of a data alert using the Alert Editor. Here are the steps to open the Alert Editor from the Scheduler:

  • In the Navigation bar, select Scheduler.
  • In the Context bar, select the Data Notifications tab.
  • In the Action bar, select +NewCreate Notifications to open the Alert Editor.
  • Define the properties of the data alert with the Alert Editor.

Edit a data notifications

You can edit a scheduled data notification (alert) through the Scheduler using the following steps:

  • Select a scheduled alert job.
    • The Alert Editor form opens.
  • Edit the details of the scheduled alert.
  • Select Done.

Export Data Notifications

The Scheduler enables you to export Data Notifications you created to be able to import them later on.

You can export Data Notifications by applying the following steps:

  • To export one scheduled job:

    • Hover on or select a scheduled data notification.

    • Select the Export button.

      The Scheduler downloads a .zip file to your machine.

  • To export multiple scheduled jobs:

    • Select multiple scheduled data notifications.

    • Select the Export button.

      The Scheduler downloads a .zip file to your machine.

Import Data Notifications

The Scheduler enables you to import .zip files that contain Data Notifications. You can import Data Notifications by performing the following steps:

  • From the Action bar, select + NewImport Data Notifications.
    • The Import Alerts window opens.
  • Select Overwrite existing alerts option if you want to delete any alerts that you created before and create new ones.
  • Browse to, or drag and drop, the .zip file that contains the notifications you want to import.

Schema Notifications

Create Schema Notifications

You can create an email alert for one or multiple certain schemas. The alert that you create is triggered upon the success or failure of a schema load.

Perform the following steps to create the data alert:

  • Open the Scheduler.

  • Go to the Schema Notifications tab.

  • From the Action bar, select + NewCreate Email Notifications.

    The Create Email Notification form opens.

  • Fill in the following options in the form to create a schema notification job.

PropertyControlDescription
Notification Nametext boxEnter the name of the email notification job you are creating.
Notify onmulti-selectSelect when you want to send the email notification.
There are 2 possible values:

  ●  Success
  ●  Failure (Default)
Select Schema(s)multi-selectSelect one or multiple schemas you want to send an alert for.
Recipientstext boxEnter the email, name, or group of recipients you want to send the email notification to.
Bodytext box(Optional) Enter the body for the email notification job you are creating.
If you did not enter a body for the email notification, Incorta sends a body with auto-generated text that contains the sender name, the schema name, its status, and URL.
  • Select Done to save the email notification.

Edit Schema Notifications

You can edit a scheduled schema notification (alert) through the Scheduler using the following steps:

  • Select a scheduled alert job.
    • The Edit Email Notification form opens.
  • Edit the details of the scheduled alert.
  • Select Done.

Search the list of Schema Notifications

The Scheduler enables you to search the list of Schema Notifications through the search bar available in the list view.

To search for a scheduled schema notification:

  • Open the Scheduler, and go to the Schema Notifications tab.
  • In the search bar, enter the schema notification job name.
    • The search result is displayed according to the keyword you entered.
Note

You can only search the Schema Notifications list using the schema notification job name.

General Scheduler Actions

Suspend and Activate scheduled jobs

When you Suspend a scheduled job, the job will pause all future actions. You can resume the job's scheduled actions by returning the job to Active status. When you create a scheduled job, its status is Active by default.

You can activate or suspend a scheduled job for the following:

  • Dashboards
  • Schema Loads
  • Data Notifications

The following steps show how to Suspend or Activate a job:

  • In the Scheduler, identify the desired scheduled job.
  • In the status column, select the current status for the scheduled job (the status will be Active or Suspended).
    • Confirm Changing Status window will appear.
  • Select Ok to confirm changing the status of the job.
Note

You can select Never Mind to cancel.

Locating Suspended Jobs

The Scheduler, by default, filters to display Active jobs only. See filter scheduled jobs to display the desired scheduled jobs based on status.

Delete scheduled jobs

The Scheduler enables you to delete one or multiple scheduled jobs.

To delete one scheduled job:

  • Select or hover on a scheduled job.
  • Select the Delete button (bin icon).
    • The Delete this job? confirmation window appears.
  • Confirm deleting the job by selecting Delete.

To delete multiple scheduled jobs:

  • Select multiple scheduled jobs.
  • Select the Delete button (bin icon).
    • The Delete these jobs? confirmation window appears.
  • Confirm deleting the job by selecting Delete.
Note

You can select Never Mind to cancel.

Filter scheduled jobs

You can filter the list of the scheduled jobs for the following according to their status:

  • Dashboards
  • Schema Loads
  • Data Notifications

A scheduled job can have one of three statuses:

  • Active (default) - Indicates that the job is active and will run according to schedule
  • Suspended - Indicates that the job is on hold and will not run
  • Completed - Indicates that the job was a one time job only and was completed successfully
Important

By default, the list displays the jobs with Active status only.

To filter the list of scheduled jobs, do the following:

  • Select the Status filter (funnel icon).
  • Select the status(es) you want to filter the list with.
  • Select OK.
    • The list will only display the jobs that have the status(es) you selected.
Note

You can select Reset to clear any selection and show only the jobs with Active status.

Create a Data Notification example

Assuming you created a Dashboard named Sales Insight for the SALES schema, the following is an example to create a data notification (alert) for this dashboard.

Important

You must have the email configuration set for your tenant in the CMC. Refer to Configure Tenants for more information.

In this example, you will create an email alert for the Sales Insight dashboard to be sent everyday to your email if the cost of the goods is less than 500.

  • Open the Scheduler and go to the Data Notifications tab.
  • Select + NewCreate Notifications.
    • The Alert Editor window opens.
  • Fill in the Name field to be: Sales Insight Alert.
  • (Optional) Add a description to this alert in the Description field.
  • Select the Type of the attachment to be HTML.
  • In the Target field, select the pen icon, and then navigate to the Sales Insight dashboard.
  • Select Tab1, and then select Add.
  • For the Condition field, select the pen icon to open the Analyzer:
    • In Data, select Manage Dataset, expand the SALES schema, and then select the SALES table.
    • Drag and drop the Sales Date column to the Grouping Dimension tray.
    • Drag and drop the Cost column to the Measure tray, and change the format to Dollar.
    • Drag and drop Add Formula to the Individual Filter tray.
    • Add the following formula in the Formula Builder: SALES.SALES.COST_OF_GOODS < 500
    • Select Validate & Save.
    • Change the Column Label to be Cost less than 500.
    • Select Save.
  • Select the Start By field to be today’s date and the current time on your machine.
  • Select the Recurrence to be Daily, Every 1 day, and No End for example purposes.
  • In the Send To field, select +:
    • Add your email address.
    • Select Add.
  • Select Done.