Job Types
Overview
The My Jobs Dialog supports the display of the following job types:
Analysis Panel Refresh
An analysis panel refresh job is created on invocation of Refresh at an analysis panel (chart, crosstab, map or Venn diagram).
Note that the My Jobs Dialog is not displayed automatically at creation of this job type.
Audit Joins
This job type is created on clicking the Audit Joins job in the Joins configuration interface.
When the job completes, a View Results button is shown. Clicking it displays the Audit Joins – Results dialog.
A Joins Report is displayed therein, documenting the following:
Missing tables
Missing columns
Data type mismatches
Missing indexes
A Copy Results to Clipboard button is available at the bottom of the dialog.
Build Selection Rule Using AI
This job type is created on invocation of Build at the basic selection rule’s ‘Tell me what you’d like to build’ prompt, which is used to create criteria using Artificial Intelligence (AI). On the job’s successful completion, a button allows for the copying of the JSON response from the AI model.
For more information on creating basic selection rule criteria using AI, please see the Basic Selection Rule documentation.
Cache Attribute Values
This job type is created on invocation of Start Loading Values when creating a compare to list criterion in respect of an uncached attribute.
Catalog Re-sync
Invocation of Synchronize Catalog at the Catalog configuration interface displays an ‘Are You Sure?’ dialog. If you elect to proceed, a Catalog re-sync job is created.
During the job’s execution, the catalog representation of the currently-displayed database is updated to reflect its latest structure. Any tables or columns that include apostrophes in their names are ignored by the cataloging process (server log entries are created to advise of this fact).
If a table has been removed from the database in respect of which the catalog is being synchronized, any joins relating to the missing table will need to be removed manually in RPI.
On completion of the job, an orange advisory message is shown at the Catalog configuration interface. Clicking Refresh updates the interface with the latest table and column information.
Connectivity Test
This job type can be created in three contexts:
In the Channels configuration interface, by clicking Create new job to test this channel at a variety of channel types (for further details, please see the Configuration Workbench documentation). Invocation in this context creates a ‘Test [channel name] channel connectivity’ job.
On completion, the job assumes one of the following latest activity statuses:
Test completed successfully
Test completed with errors
Test failed
A View Results button is available on completion. Clicking it displays the Connectivity Test Results dialog.
The tests performed are dependent on the channel type:
General
Data extract: if the channel is configured to:
Write to file system: Access network folder path
Write to an FTP site: Connect to FTP service
Write to an external content provider: Validate default external content provider
Eloqua: Connect to Eloqua service, Validate service URL
LuxSci: Connect to LuxSci service
Salesforce Marketing Cloud (SFMC) Email: Connect to SFMC web service, Connect to SFMC FTP service, Connect to FTP service (if Import via file is checked)
SFMC Data Transfer: Connect to SFMC Cloud web service, Connect to SFMC FTP service
SendGrid Email: Connect to SendGrid web service, Connect to SendGrid SMTP, Connect to Callback service, Connect to FTP service (if Import via file is checked)
Mobile
Azure Notification: Connect to Windows Azure Notification Hub service
Azure Push Direct Notification: Connect to Azure Push Direct Notification service
Twilio SMS: Connect to Twilio
Data Onboarding
Facebook Audience: Connect to Facebook service
Google Ads Customer Match: Connect to Google Ads service
CRM
Salesforce.com: Connect to Salesforce, Log into Salesforce
Web
Alchemer: Connect to Alchemer
If desired, you can copy the contents of the dialog to the clipboard using the button at its footer.
In the FTP Locations configuration interface, by clicking Create new job to test this FTP location. Invocation in this context creates a ‘Test [location name] FTP location connectivity’ job.
On completion, the job assumes one of the following latest activity statuses:
Test completed successfully
Test completed with errors
Test failed
A View Results button is available. Clicking it displays the Connectivity Test Results dialog. A single test is performed:
Connect to FTP location
If desired, you can copy the contents of the dialog to the clipboard using the button at its footer.
In the Web Adapters configuration interface, by clicking Create new job to test this adapter at Google Analytics or Web Events adapters. Invocation in this context creates a ‘Test [adapter name] adapter connectivity’ job.
On completion, the job assumes one of the following latest activity statuses:
Test completed successfully
Test completed with errors
Test failed
A View Results button is available. Clicking it displays the Connectivity Test Results dialog. The tests performed are dependent on the adapter type:
Google Analytics adapter: Connect to Google Analytics, Validate metrics
Web Events adapter: Load web event tracking page, Register test event on event queue
If desired, you can copy the contents of the dialog to the clipboard using the button at its footer.
In the External Content Providers configuration interface, by clicking Test connectivity. Invocation in this context creates a ‘Test [external content provider name] provider connectivity’ job. On completion, the job assumes one of the following latest activity statuses:
Test completed successfully
Test completed with errors
Test failed
A View Results button is available. Clicking it displays the Connectivity Test Results dialog. A single test is performed:
Accessing root folders
If desired, you can copy the contents of the dialog to the clipboard using the button at its footer.
In the Queue providers configuration interface, by clicking the Test connectivity button at the queue provider (for further details, please see the Configuration Workbench documentation). Invocation in this context creates a ‘Test [Queue provider name] provider connectivity’ job.
A View Results button is available on completion. Clicking it displays the Connectivity Test Results dialog. The following tests are performed irrespective of the queue provider type:
Write to the test queue
Read from the test queue
Customer View
This job type is created on invocation of Choose at the Search overlay in the Single Customer View interface. It is used to retrieve full details of a given record (typically a customer), which are then displayed in the Single Customer View interface. No results are available at the job.
Customer View Search
This job type is created on invocation of Search at the Search overlay in the Single Customer View interface.
It is used to retrieve a list of records matching entered search criteria, which are then displayed in a list of Search Results. No results are available at the job.
Delete Staged Email Offer Content
This job type is created on invocation of Delete Staged Email Content at an email offer.
Download Asset from ECP
When you invoke Copy to folder at an external content provider file, an External file download job is created.
On its successful completion, an Open Folder button is available. Clicking it opens the folder to which the file was downloaded in Windows Explorer and highlights the file itself therein.
Email Delivery Test
In the Offer Designer’s Email tab, clicking OK at the Test Inbox Delivery dialog creates a Test email delivery for [offer name] job.
The dialog details the status of each link in the offer content.
On completion, a View Results button is displayed. Clicking it displays the Email Delivery Results dialog.
The dialog contains:
Inbox Preview Overview tab: this tab displays inbox preview images for a number of email clients. If system configuration setting EmailCheckerSandboxSwitch is set to 1, a series of sample images are displayed.
If system configuration setting EmailCheckerSandboxSwitch is set to 0, genuine preview images are displayed.
A Zoom image button accompanies each image on hover. Invocation displays a larger version of the image in a fixed panel. This can be closed by clicking Close or by clicking off the panel.
If a test was failed, the image is not displayed and the legend 'Failed' shown instead (accompanied by a cross icon). A warning icon is displayed if a test timed out.
Inbox Preview Details tab: this tab provides a more detailed view of inbox deliverability test results.
A list of email client-specific tests is displayed to the left. Successful tests are accompanied by a tick, and failed tests by a cross.
When you highlight a test, the right-hand panel is updated to display Inbox Preview Details. Preview images are displayed (sample images if EmailCheckerSandboxSwitch is set to 1, genuine preview images if set to 0). Window and Full Page images are displayed for both Normal and Blocked content.
A zoom image button accompanies each image on hover. Invocation displays a larger version of the image in a fixed panel. This can be closed by clicking Close or by clicking off the panel.
Spam Check Results tab: this tab displays spam check results.
A series of spam checker tests displayed to the left. Successful tests are accompanied by a tick, and failed tests by a cross.
When you highlight a spam test, the right-hand panel is updated with the following:
If you wish, you can copy the spam check results to the clipboard.
Clicking the Close button removes the Email Validation Results dialog from display.
Email Link Test
In the Offer Designer’s Email tab, clicking the Test Email Links button creates a Test email links for [offer name] job.
On completion, the job’s status advises of the status of the links in the offer content.
A View Results button is available, and clicking it displays the ‘Test email links…’ dialog.
The dialog details the status of each link in the offer content. You can right-click an entry in the Address column to copy the link address to the clipboard.
A message at the bottom highlights the fact that the links were tested from the server to which currently connected (as opposed to the client on which RPI is running).
Export Tenant Items
This job is used to export items from a tenant so that they can be used as a template for the creation of other Tenants. The following can be exported:
Users in Tenant
User Groups
User Group Permissions
Users In Groups
User Alert Registration
Any existing folders at the export location are overwritten at the job’s execution.
For more information please see the Configuration interface documentation.
An Open Folder button is available on the job's successful completion.
File Download
On clicking Save at a ‘Save…’ or ‘Download…’ Windows file system dialog, a Download [file name] job is created.
On the job’s assuming a Download Completed status, an Open Folder button is displayed.
Note that if you close and re-open the RPI client application, the Open Folder button is replaced by a Download button; you must save the file again before the Open Folder button is displayed.
Clicking Open Folder opens Windows Explorer and highlights the downloaded file.
File Export
This job type is created when you export one or more files or configuration collections.
On its successful completion, an Open Folder button is available. Clicking it opens the folder to which the file(s) was or were downloaded in Windows Explorer.
File External Copy
This job type is created on invocation of Copy to other Tenants, which can be invoked both in the context of one or more files or configuration collections.
On its successful completion, a Copy results to clipboard button is available. Invocation copies details of the success or otherwise of the copying of each file (including dependent files) to each selected tenant.
Fulfillment Test
This job type can be created in the following contexts:
Email: the job can be created by clicking Send Test Emails in the Email tab within the Offer Designer, or by clicking the same button in the Preview…Dynamic Content dialog. Doing so creates a Send test emails for [offer name] job.
Emails are delivered in accordance with specified options. Email addresses that appear in more than one seed group are de-duplicated. Any URL parameters defined by association of channels through which test emails are sent with PURL adapters, or any parameters added automatically to support web analytics adapters with which the channels are associated are not added to URLs contained within test email content.
SMS: the job can be created by clicking Send Test SMS Message in the SMS tab within the Offer Designer. Doing so creates a Send test SMS message for [offer name] job.
The SMS message is delivered in accordance with your stipulations. If duplicate cellphone numbers are targeted, they are deduplicated. Attributes are substituted in the delivered message where a seed column name matches the embedded attribute name.
Generate Audience From [Selection Rule]
The Generate Audience From [Selection Rule] job is created when generating a clustered audience from a standard selection rule.
On the job’s completion, a View Results button is shown; clicking it displays the clustered audience’s test execution results in the Insights Window.
More information on generating clustered audiences is provided in the Standard Selection Rule documentation.
Joins Refresh
Initiating a joins refresh (in respect of the data warehouse or an auxiliary database) in the Joins configuration interface results in the created of a Refresh Joins job.
On completion, any joins extant within the current database context that were not configured at the RPI server are created there. The job assumes a Notification Completed status. If shown, the Joins configuration interface is updated automatically.
Publish To Web
Execution of this job type publishes a landing page, or smart asset, to a web publish site or folder.
When objects such as realtime decision logic or images are published, if one or more values are supplied at string list system configuration setting RealtimeAPIPublishAddresses, objects are published to each address supplied at the setting. If no values are supplied for the setting, objects are published to the address specified at system configuration setting RealtimeAPIAddress.
Publish jobs are also created when saving realtime layouts, and when publishing smart assets from the Realtime Layouts interface.
Upon completion, a Copy published location to clipboard button is available. If invoked at a rule published directly to the realtime cache, a message advises that no published location is available.
Re-subscribe Contacts
When an email channel is selected in the Channels configuration interface, you can create a Re-subscribe contacts job by clicking the Choose contacts to re-subscribe to this channel button, specifying the contacts’ email addresses in the Re-Subscribe Contacts dialog (as described in the Configuration Workbench documentation), and then clicking the Create job to re-subscribe these Email Addresses button in the same context.
Doing so creates a Re-subscribe contacts for [channel name] job.
The job removes the email addresses provided from the channel's email subscription table, and also from the email provider’s subscription records.
On completion, the job’s status advises of the number of contacts successfully re-subscribed at the channel.
Refresh Value Lists
A Refresh Value Lists job refreshes any database value lists with the latest set of values from the data warehouse.
It is executed on invocation of Save in the Value Lists configuration interface, following a change to database value list(s) therein, or as required when an audience or interaction is loaded.
Note that the Refresh Value Lists job is a system job, which is not normally shown to users.
Retrieve Data Viewer Results
A Retrieve Data Viewer results job is created on population of the Data Viewer. For more information, please see the Rule Designer documentation.
Note that the My Jobs Dialog is not displayed automatically at creation of this job type.
Rule Count
A rule count job is created on running a selection rule in the Rule Designer.
Note that the My Jobs Dialog is not displayed automatically at creation of this job type.
The job’s most recent activity status displays the count of matching records retrieved.
Rule Export
Upon saving a selection rule export file, an Export rule ‘[rule name]’ job is created.
On completion, its most recent activity status is set to ‘Export [n] records’. Its status is set to Download Completed, and an Open File button is displayed.
Note that if you close and re-open the RPI client application, the Open File button is replaced by a Download button; you must save the report again before the Open File button is displayed. On clicking Open File, the export file is displayed.
Its contents are accordant with the associated rule, export template and export settings. If exporting a selection rule, and the selected export template contains one or more attributes from a joined table, and if the values of said attribute(s) are NULL, all rows targeted by the selection rule are exported, with blank attribute values in the export file as appropriate.
A rule export produces a single file on the RPI server, within the folder defined by tenant system configuration setting FileOutputDirectory or cluster setting GlobalFileOutputDirectory (as appropriate). The file’s structure is defined by the selected export template. The data contained there is sourced from data warehouse records that match the criteria specified in the rule. If a selection rule, data is deduplicated in accordance with the selected export template's Deduplication property.
Save Workflow Diagnostics
This job type is created at invocation of Download Diagnostic information for this Workflow Instance in the Results Window. Its description is 'Saves workflow diagnostics for workflow instance ID [nnnnn]'.
The job controls the download of a diagnostics zip file, which contains a series of files that can be used e.g. in determining why a workflow failure occurred.
On the job's successful completion, an Open File Location button is shown. Clicking it displays the diagnostics zip file in Windows Explorer. The zip file contains the following:
AuditHistory.txt
ExecutionPlan.txt: used by the Execution Service to execute activity within the workflow.
ExecutionSchedule.txt: the state of activity execution at the Execution Service.
Interaction Workflow.json: a dump from the table of the same name.
QueryTrace.txt
ServerLog.txt
Summary.txt: high-level summary information.
SystemHealth.json
For each audience/fulfillment activity:
Audience: dump from the DataWorkflow table.
Instance: serialized activity details.
Log: relating to the current activity's execution.
Files: the exported interaction files.
Telemetry.txt: tenant telemetry information for a previous number of days defined by tenant system configuration setting DiagnosticsTelemetryTimespan. The file includes the following information:
File type usage in the last n days
Workflows in the last n days
Published files in the last n days
Configured channels
Selection Rule Waterfall
Upon saving a selection rule waterfall report from the Save Selection Rule Waterfall Report As… Windows file system dialog, a Waterfall for selection rule ‘[rule name]’ job is created.
Following the job’s completion, and assumption of a Download Completed status, an Open File button is displayed.
Note that if you close and re-open the RPI client application, the Open File button is replaced by a Download button; you must save the report again before the Open File button is displayed.
On clicking Open File, the waterfall report is displayed in Excel (which must be installed for the report to be run). A waterfall report contains:
Initial header section, containing selection rule name and resolution level.
Summary grid, displaying, for each criteria list within the rule:
Name of the criteria list
And/Or relationship to the previous list (if not the first list)
Count after application of the criteria list
Drop-off after application of the criteria list (if not the first list)
For each criterion within each criteria list:
Name of the criterion
Count after application of the criterion
Drop-off after application of the criterion (if not the first criterion)
If configuration setting EnableNonNestedStyleWaterfallReport is set to True, the contents of the report that are rolled up using the controls to its left are instead shown inline.
Stage Email Offer Content
This job type is created on invocation of Stage Email Offer Content at an email offer.
Upon its successful completion, you can copy the publish location to which the email offer content was staged using the Copy published location to clipboard button.
Unpublish
Execution of this job type unpublishes a landing page or smart asset from a web publish site or folder.
An unpublished landing page or smart asset’s files are deleted; however, any relevant cached details are not removed from the realtime cache.
Update Model Attributes
This job type is created on invocation of Update AI Model in the SQL Database Definitions configuration interface. It allows you to update the AI model associated with the definition with details of the definition's attributes.
On successful completion of the job, a Results button is shown. Clicking it displays a Window in which you can view a list of attributes, along with results for each.
A Copy Results button is available at the Window’s footer.
Update Table In The Cache
This job type is created when you click the Create new job to update the cache button in the Cached Attribute Lists configuration interface.
The job updates the realtime cache with the latest data for the cached attribute list's attributes from the database.
Upload Asset to ECP
Invocation of Copy to External Folder at a file in the File System Dialog creates this job type (where ‘ECP’ stands for ‘External Content Provider’).
Upload File to ECP
This job type is created on invocation of Upload to Folder at an external folder in the File System Dialog (where ‘ECP’ stands for ‘External Content Provider’).
Validate and Load File
This job type is created on invocation of Validate and Load at the Data Source Designer.
Validate Channels
When you save a newly-created email channel, or when an existing email channel's Recipient email address field is changed, a Validate channels job is created.
The job creates a join is between the email suppression table (as defined by system configuration setting EmailUnsubscribersTable) and the Recipient email attribute's resolution table.
The following additional columns are added to the offer history table if they if do not exist already:
Selected
Sent
Delivered
Opened
Unsubscribed
ClickThrough
HardBounced
SoftBounced
These columns are used to store additional channel-specific state information – for example, indicating whether an individual clicked on a URL in an email delivered via an email channel.
Following the job’s completion its status is set to Completed, and a View Results button is shown. Clicking the button displays the Channel Validation Results dialog, which details the nature of any issues that occurred during the job’s execution.
Validate Audience Definitions
When you save a newly-created audience definition or make changes to an existing audience definition’s offer history table or transactional configuration, a validate audience definitions job is created.
It is the job’s responsibility to ensure that the offer history tables within the data warehouse match the stipulations made within the audience definitions.
Following the job’s completion its status is set to Synchronization Completed, and a View Results button is shown. Clicking the button displays the Audience Definition Validation Results dialog, which details the nature of any issues that occurred during the job’s execution.
Validate SQL Expression
This job type is created upon validation of a SQL Expression attribute, or custom SQL expression within a standard selection rule.
Workflow Waterfall Report
Upon saving a workflow waterfall file from the Save Waterfall Report As… Windows file system dialog, a Waterfall for workflow instance [ID] job is created.
On completion, its status is set to Download Completed, and an Open File button is displayed.
Note that if you close and re-open the RPI client application, the Open File button is replaced by a Download button; you must save the report again before the Open File button is displayed.
On clicking Open File, the waterfall report file is displayed in Excel (which must be installed for the report to be run). It contains the following:
Summary tab: this tab displays the following information:
Interaction Name
Trigger Name
Start Date
Last Event Date
Workflow ID
Execution Mode
Fulfillment Summary: for each fulfillment activity, the following are shown:
Offer Channel Name
Activity
Channel
Fulfillment Option
Count
One tab per results-producing activity.
The following are common to all activity tabs:
Activity Name
Activity Type
Start Date
Last Event Date
Input Activity
Total Count
In addition, the following additional information is displayed for specific activity types:
Batch audience:
Audience Summary
Input Filters: Activity, State(s)
Segment Summary: one row is displayed per segment. For each row, the following are shown:
Name
One column per metadata attribute
Count
Audience Block Summary: one row is shown per audience block. For each block, the following are shown:
Name
Input
Count
The following additional information is shown at suppressions blocks:
Total before suppressions
[Suppression 1]
[Suppression n]
Total after suppressions
Interactive activity: the tab is displayed as per a batch audience if the activity is configured with an audience. If not, the Audience Block Summary is not shown.
Offer:
Input Filters
Fulfillment Channels: the following are shown for each channel:
Offer Channel Name
Channel
Fulfillment Option
Count
State Results: the following are shown for each state result:
Name
Category
Count
[Email offer only] - Specific Link Clicks: for each specific link clicked, the following are shown:
Name
Count
Export: the tab is displayed as per an offer