Creating and editing scheduled tasks PLUS

Training course

Note: This is a licensed feature. For more information, contact your AiSP or ASI Technical Support.

Note: The Default publishing server must be enabled; if this publishing server is disabled, your scheduled tasks will not run. To determine the Default publishing server, go to RiSE > Maintenance > Publishing servers. The Default column will indicate which publishing server (if there are more than one) is the default.

Do the following to create a new scheduled task:

  1. Go to RiSE > Process automation.
  2. (Tasks tab) Click Add new task.
  3. Enter a Name that indicates the purpose of the task.
  4. (optional) Enter a task Description.
  5. Select Scheduled task as the task Type.

    Selecting scheduled task

  6. (Triggers tab) Create Triggers that tell the task when to run.

    7. Viewing the triggers tab

    Triggers determine when and how frequently the communications are sent. You can schedule one time, daily, weekly, and monthly communications.

    Adding a trigger

    1. Click Add trigger.
    2. Select a trigger Type.

      System administrators can add triggers to scheduled tasks, enabling iMIS to run a task when a pre-defined trigger event occurs. Once a trigger event occurs, iMIS will run the appropriate task.

      You can add triggers to tasks as you create new tasks, or you can add triggers to already-defined tasks. Select the type of trigger to use:

      On a schedule

      System administrators can specify the exact time a task will run, as well as the frequency with which the task is run.

      • Select a Frequency of One time or Daily. You can Schedule a Daily task to run at specified intervals.
      • If you select a Frequency of Weekly or Monthly, you can select the Day of week or Day of month when the task will run. You can select multiple days of the week or month.
      • Select the Start date and time. When using a Frequency of Daily, Weekly, or Monthly, you can also select an End date and time. The start date and time is based on the system Time zone setting.

      On a system event (use sparingly)

      Warning! System events (database changes) will create triggers directly on the database table. These triggers will run every time the selected actions occur: Row inserted, Row deleted and/or Row updated. To minimize performance impacts avoid overusing these triggers.

      The task can be defined to run based on specific changes to database tables in the iMIS system:

      1. Select a Table:
        • The drop-down contains commonly used tables. If you would like to use a table that is not listed, select Other and enter a Table Name.
        • The primary key from the trigger table can be used in an IQA query by adding a filter value of "@TriggerId". For example, if there is a trigger for Activity, reference the triggered row in an IQA query by adding a filter of CsActivity.Sequence = "@TriggerId".
        • If the table has more than one primary key, add multiple filters in the form of "@TriggerId1" and "@TriggerId2". For example, Order_Lines has a composite primary key of ORDER_NUMBER and LINE_NUMBER. Reference the triggered row in an IQA query by adding two filters of CsOrderLines.Order Number = "@TriggerId1" and CsOrderLines.Line Number = "@TriggerId2".
        • If using the @TriggerId value, leave Add To Search? set to No in the query filters.
      2. Select at least one type of data change for which the trigger is run. You can select more than one type of data change:
        • Row inserted
        • Row deleted
        • Row updated
          • Any update - select to run the trigger when any column in a row has been changed or adjusted.
          • Specific column - select a specific Column from the previously defined table. Enter any specific Value changed from and Value changed to for the selected column. Leave the values blank to indicate any change of the column value.

    1. Select Enabled to enable the new trigger.
    2. Save the new trigger.
  7. (optional) (Data sources tab) Create and manage query data sources for the task.

    8. Viewing the data sources tab

    All query data sources created for this task are listed. The name of all data sources will populate in a drop-down when defining a Condition or Action. You cannot delete a data source if the data source is selected within a Condition or Action, however not every data source you have defined must be used when creating a Condition or Action.

    1. Select Add data source.
      • Enter a Data source name. It is recommended that you choose a name that indicates the type of records returned by the data source. The name must be unique.
      • Select an existing query or click Create source query to add a new query.
        • If you select an existing query, the $/Common/Tasks/Queries folder opens by default.
        • If you choose to add a new query, you are taken to the Intelligent Query Architect where you can define a new query.
    2. Save your data source.
    3. If needed, add additional data sources.
  8. (optional) (Conditions tab) Specify Conditions that must be met in order for the task to run.

    9. Viewing the Conditions tab

    1. If a query data source was defined on the Data sources or Actions tab, select one of the following options:
      • Use existing data sources - select a previously defined data source from the drop-down that will only display data sources that are not being used in any otherConditions.
      • Use results of IQA query as data source - select this option to define a new data source.
        • Enter a Data source name. It is recommended that you choose a name that indicates the type of records returned by the data source.
        • Select an existing query or click Create source query to add a new query.
          • If you select an existing query, the $/Common/Tasks/Queries folder opens by default.
          • If you choose to add a new query, you are taken to the Intelligent Query Architect where you can define a new query.
    2. If there were no previously defined data sources from the Data sources or Actions tab, provide the following required information:

      • Enter a Data source name. It is recommended that you choose a name that indicates the type of records returned by the data source.

        Select an existing query or click Create source query to add a new query.

        • If you select an existing query, the $/Common/Tasks/Queries folder opens by default.
        • If you choose to add a new query, you are taken to the Intelligent Query Architect where you can define a new query.

    3. Save your data source.
    4. If needed, add additional data sources.

    Warning! When a task is triggered, it only executes its action if the selected data sources return one or more records or no Conditions are defined.

    Note: This data source will populate on the Data sources tab once you click Save. You can also edit and remove data sources from the Conditions tab.

    All query data sources created for this task are listed. The name of all data sources will populate in a drop-down when defining a Condition or Action. You cannot delete a data source if the data source is selected within a Condition or Action, however not every data source you have defined must be used when creating a Condition or Action.

    1. Select Add data source.
      • Enter a Data source name. It is recommended that you choose a name that indicates the type of records returned by the data source. The name must be unique.
      • Select an existing query or click Create source query to add a new query.
        • If you select an existing query, the $/Common/Tasks/Queries folder opens by default.
        • If you choose to add a new query, you are taken to the Intelligent Query Architect where you can define a new query.
    2. Save your data source.
    3. If needed, add additional data sources.
  9. (Actions tab) Define the action the task performs when it runs. The Actions tell the task what to do when it runs. When the Triggers occur and the Conditions are met, the task executes the Actions. In this case, the action is sending a communication to a recipient list generated by a selected recipient data source using a specified communication template.

    10. Viewing the actions tab

    1. Click Add action.
    2. Select an action Type.

      3. Note: Some of the following list items might not be displayed depending on the Type that is selected.

      The following are the action types to choose from:

      • 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.

    3. (optional) If you select Type of Send a communication, select a Recipient data source query, which determines the recipient list for your communication. Data sources added on the Conditions or Data Sources tab are available. For more information on creating recipient data source queries, see Creating a list of contacts to email.

      4. Note: You are not required to select a recipient data source if the communication template used by the action already contains a recipient data source. If you select a recipient data source in the action and the communication also contains a recipient data source, the action’s recipient data source is used.

    4. (optional) If needed, you can click Add new data source to select additional query data sources if you select Type of Send a communication.

      • Enter a Data source name. It is recommended that you choose a name that indicates the type of records returned by the data source.

      • Select an existing query or click Create source query to add a new query.
        • If you select an existing query, the $/Common/Tasks/Queries folder opens by default.
        • If you choose to add a new query, you are taken to the Intelligent Query Architect where you can define a new query.
    5. If you select the Type of Send a communication, specify the Communication email template that you want to send to the recipient list:
      • Select an existing email template.
      • Create a new template.

      6. Note: For more information about templates, see Creating a newl communication template.

    6. (optional) If you select the Type of Run a stored procedure and your task contains a Trigger with the Type of On database change, an option to Enable TriggerIDs as parameters is available. The stored procedure specified must contain at least one TriggerId parameter if this option is enabled. Select the information icon for specific parameter names and data types depending on which database table was selected in the Trigger.

      7. Note: The option to run a custom stored procedure is only available to self-hosted users.

    7. If you select the Type of Run content workflow, specify the communication email template that you want to send to the recipient list:
      • Navigation workflow communication sends a notice for navigation that has expired.
      • Content workflow communication sends a notice for content that has expired.

      For more information on content workflow, see Workflow Management tab.

    8. Save the action.

      9. Note: You can also edit and remove actions from the Actions tab.

    All query data sources created for this task are listed. The name of all data sources will populate in a drop-down when defining a Condition or Action. You cannot delete a data source if the data source is selected within a Condition or Action, however not every data source you have defined must be used when creating a Condition or Action.

    Adding a new data source

    1. Select Add new data source.
      • Enter a Data source name. It is recommended that you choose a name that indicates the type of records returned by the data source. The name must be unique.
      • Select an existing query or click Create source query to add a new query.
        • If you select an existing query, the $/Common/Tasks/Queries folder opens by default.
        • If you choose to add a new query, you are taken to the Intelligent Query Architect where you can define a new query.
    2. Save your data source.
    3. If needed, add additional data sources.
  10. To activate the task, select Enabled.

    Enabling the trigger

  11. Save the task.
  12. (optional) Click Run task now to run the task immediately.
  13. (optional) (Data sources tab) Create and manage query data sources for the task.
  14. (optional) Review the Logs to determine which scheduled tasks have been run, which actions have been performed, and whether any scheduled tasks did not complete successfully.

  15. Note: When clicking Run task now, DO NOT refresh your browser; otherwise, the task will start over. To see the log, click the Logs tab, then click the Find button. The log for the last runs of the task will be listed. Also keep in mind when you click Run task now, you will see a message that says Your task was executed. You will not see the log for this last run until you go to the Logs and click Find.

    Viewing the logs tab
  16. You can search for specific scheduled tasks based on the name of the task, the status of the task, or the date when the task was initiated.
    1. From the Staff site, go to RiSE > Process automation, and select the Logs tab. You can also review the log for each scheduled task by opening the task and reviewing the task Logs tab.
    2. You can search for specific scheduled tasks based on the name of the task, the status of the task, or the date when the task was initiated.

      3. You can search for scheduled task logs based on the following statuses:

      • In progress - The task has been initiated, and is currently running. The task has not yet ended.
      • Completed - The task has been initiated, and ended. There were no results by which a Succeeded or Failed status could be determined. The task evaluated the data source specified in the Conditions, but there were no results for the task to act upon. The task only executes its action if the selected data sources return one or more records, or no Conditions are defined.
      • Failed - The task was initiated and ended, but the task did not complete successfully.
      • Succeeded - The task was initiated and ended, and the task completed successfully.
    3. A list of scheduled tasks is displayed. You can click the name of the scheduled task to open a task editor.
    4. To view the log for a scheduled task, click the Expand ( + ) icon. This will open the log details for the specified scheduled task. You can also click Expand All to see log details for all scheduled tasks.

      5. The log identifies the following events for most tasks:

      • Trigger execution - This is the moment when the scheduled task is initiated.
      • Datasource evaluation - The scheduled task evaluated the data source specified in the Conditions. If there are results for the task to act upon, this event will have a Succeeded status, and an Action execution event is initiated.
      • Action execution - If the Datasource evaluation is successful, the task continues to perform the action defined for this task.

      If any of these events cannot be completed, a Failed status is displayed, and the task is ended. You can then investigate why a task event failed.

    5. You can also do one of the following to delete logs that you no longer need:
      • Click the red X to delete a selected log.
      • Click Delete All Logs to delete all recorded logs on the Logs tab.
    6. By default, the list of scheduled tasks will only display the latest 500 entries. You can adjust this configuration option by editing the PagedResults.Maxrecords option in the web.config file located in the C:\Program Files (x86)\ASI\iMIS\Net\web.config file. If this configuration option does not exist in or removed from the web.config file the log will still display the latest 100 entries.

      7. Note: If you are not self-hosted, you must contact your host for assistance modifying web.config files.

    7. You can manage the scheduled task log entries to avoid expanding your database size. See Process automation for more information.