Understanding scheduled tasks

Quick Tutorial Full Training

System administrators can add scheduled tasks, enabling iMIS to run a task when a pre-defined trigger (Process automation trigger), event, or scheduled time frame occurs. Once a trigger event occurs, iMIS will run the appropriate task.

Each scheduled task can have Process automation Triggers, Data sources, Conditions, and Actions. A scheduled task must contain Process automation Triggers and Actions; Data sources and Conditions are optional.

Determining the task's purpose: Defining the Action

The following types of scheduled tasks that are termed Actions:

  • Send a communication - Automatically sends a communication on a scheduled basis. See Sending scheduled communications and Creating an automatic email.
  • Calculate engagement scores - Automatically calculates engagement scores. See Scoring.
  • Issue and email gift receipts - Select a receipt data source and communication you want to send.
  • Process pending donation premiums - Use this task to process premium orders that were not processed in the iMIS Desktop before you upgraded to iMIS EMS. See Resolving pending premiums for more information.
  • Generate recurring donation invoices - Generates a recurring donation batch. Click Run on the Generate invoices tab to run this task. See Generating invoices for more information.
  • Send invoices to Pay Central - You can select an Invoice source query to use as the source of the invoices you want to submit for processing.

    Note: The Invoice source query you select must include the code_InstructionKey column. Use the following values:
    -- Property - Recurring Transaction Instruction Key
    -- Alias - code_InstructionKey
    If your queries are not updated, you will receive an error.

    Click Run on the Submit invoices tab to run this task. See Submitting invoices for more information.

  • Retrieve payments from Pay Central - This refreshes the payment status of the submitted payments and writes the submitted payments back to iMIS. Click Retrieve processed payments on the Retrieve processed payments tab to run this task. See Retrieving process payments for more information.
  • Run a report - See Sending scheduled reports.
  • Run a stored procedure - Enter the name of the stored procedure you want to run.
  • Note: Only self-hosted users can run custom stored procedures.

  • Run content workflow - Select the communications for the content and navigation workflows.
  • Update campaign data- This type can be used to update all related campaigns, appeals, solicitations, and source codes after the output generation takes place.
  • Note: This type is limited to users with the Campaign Management license.

Once you decide on the type of task you want to send, you can define how often the task will run, what conditions must be met in order for the task to run, and the data sources that comprise the task:

Choosing the task frequency: Defining the Trigger

Scheduled tasks are sent based upon a specific occurrence called a Process automation Trigger. For example, the occurrence could be as simple as every Saturday and Wednesday at noon, or on the 15th of each month at 7:00 PM. The frequency combinations of dates and times is truly up to you!

When viewing a scheduled process automation task, staff users can see when the task was last run and when it is due to run again. If there is no scheduled run time, a message displays informing the user.

The second type of scheduled task trigger is called On database change. To minimize performance impacts, it is suggested that this trigger be used sparingly.

Warning! An On database change trigger will fire every time the specified table is accessed. Whenever possible, add your triggers to low-volume tables. Triggers on high-volume tables, such as Trans and ChangeLog can be difficult to troubleshoot and will cause performance problems.

Circumstances surrounding the task: Specifying Conditions

Conditions allow you to filter when the tasks are sent by specifying query data sources. When you set up Conditions for a scheduled task, the data source, or query, must return records when a Process automation Trigger (specified date and time) occurs in order for the task to execute its Actions.

For example, you have a scheduled task enabled that sends a communication to all staff members every Monday at 8:00 AM. The purpose of the communication is to inform the staff of any new members who joined in the previous week.

To ensure that communications are not being sent when there are no new members, you would need to add the query that identifies last week's new members to the Conditions tab. If that query returns no results, meaning that no new members joined last week, then the task would not execute.

New queries added to the Conditions tab automatically appear in the Data sources tab.

Expanding the task: Defining Data sources

Data sources allow you to define and edit IQA queries to be used by Conditions, or within the Actions.

The Data sources tab shows a list of all data sources that are available to be used in the task. This tab is mainly used to manage all data sources being used throughout the task. You can edit any aspect of the data source from this tab, or delete the data source altogether if it is not being used by the task. The data sources can be used in the following areas of the task:

  • Conditions - If included as a condition, the task will only run if the data source returns results
  • Actions - Insert the data source into an Action where applicable

The same data source can be used in any combination of these, including in multiple different actions. A new data source can be added in the data sources tab, but it can also be added right from where you want to use it - in the Conditions, Alert, or Action.

Reviewing the task: Checking the Logs

You can review Logs to determine which scheduled tasks have been run, which actions have been performed, and whether any scheduled tasks did not complete successfully.