Monitor scheduled queries
Adobe Experience Platform provides improved visibility for the status of all query jobs through the UI. From the Scheduled Queries tab, you can now find important information about your query runs that includes the status, schedule details, and error messages/codes should they fail. You can also subscribe to alerts for queries based on their status through the UI for any of these queries through Scheduled Queries tab.
Scheduled Queries
The Scheduled Queries tab provides an overview of all your scheduled CTAS and ITAS queries. Run details can be found for all scheduled queries as well as error codes and messages for any failed queries.
To navigate to the Scheduled Queries tab, select Queries from the left navigation bar followed by Scheduled Queries
The table below describes each available column.
Run once
and Scheduled
. Queries can be filtered according to their run frequency.Success
, Failed
, In progress
, and No runs
.The current status of the scheduled query. There are five potential values, Registering, Active, Inactive, Deleted, and a hyphen.
- The hyphen indicates the scheduled query is a one-time, non-recurring query.
- The Registering status indicates that the system is still processing the creation of the new schedule for the query. Note, you cannot disable or delete a scheduled query while it is registering.
- The Active status indicates that the scheduled query has not yet passed its completion date and time.
- The Inactive status indicates that the scheduled query has passed its completion date and time.
- The Deleted status indicates that the query schedule has been deleted.
Customize table settings for scheduled queries customize-table
You can adjust the columns on the Scheduled Queries tab to your needs. To open the Customize table settings dialog and edit available columns, select the settings icon ( ) from the top right of the screen.
Toggle the relevant checkboxes to remove or add a table column. Next, select Apply to confirm your choices.
Manage scheduled queries with inline actions inline-actions
The Scheduled Queries view offers various inline actions to manage all of your scheduled queries from one location. Inline actions are indicated in each row with ellipsis. Select the ellipsis of a scheduled query that you want to manage to see the available options in a pop-up menu. The available options include Disable schedule or Enable schedule, Delete schedule, and Subscribe to query alerts.
Disable or enable a scheduled query disable
To disable a scheduled query, select the ellipsis of a scheduled query you want to manage, then select Disable schedule from the options in the pop-up menu. A dialog appears to confirm your action. Select Disable to confirm your setting.
Once a scheduled query is disabled, you can enable the schedule through the same process. Select the ellipsis, then select Enable schedule from the available options.
Delete a scheduled query delete
To delete a scheduled query, select the ellipsis of a scheduled query you want to manage, then select Delete schedule from the options in the pop-up menu. A dialog appears to confirm your action. Select Delete to confirm your setting.
Once a scheduled query is deleted, it is not removed from the list of scheduled queries. The inline actions provided by the ellipses are removed and replaced by the grayed out add alert icon. You cannot subscribe to alerts for the deleted schedule. The row remains in the UI to provide information on runs conducted as part of the scheduled query.
If you want to schedule runs for that query template, select the template name from the appropriate row to navigate to the Query Editor, then follow the instructions to add a schedule to a query as described in the documentation.
Subscribe to alerts alert-subscription
To subscribe to alerts for scheduled query runs, select the ellipsis of a scheduled query you want to manage, then select Subscribe from the options in the pop-up menu.
The Alerts dialog opens. The Alerts dialog subscribes you to both UI notifications and email alerts. Alerts are based on the status of the query. There are three options available: start
, success
, and failure
. Check the appropriate box or boxes and select Save to subscribe. You can subscribe to alerts as long as they don’t have a Last Run Timestamp value.
See the alert subscriptions API documentation for more information.
View the query details query-details
Select the information icon ( ) to see the details panel for the query. The details panel contains all the relevant information on the query beyond the facts included in the scheduled queries table. The additional information includes the query ID, the last modified date, the SQL of the query, the schedule ID, and the current set schedule.
Filter queries filter
You can filter queries based on run frequency. From the Scheduled Queries tab, select the filter icon ( ) to open the filter sidebar.
To filter the list of queries based on their run frequency, select either the Scheduled or Run once filter checkboxes.
Once you have enabled your filter criteria, select Hide Filters to close the filter panel.
Query runs schedule details query-runs
To open the schedule details page, select a query name from the Scheduled Queries tab. This view provides a list of all the runs executed as part of that scheduled query. The information provided includes the start and end time, status, and dataset used.
This information is provided in a five-column table. Each row denotes a query execution.
successful
failed
or in progress
.Details of the query being scheduled can be seen in the Properties panel. This panel includes the initial query ID, client type, template name, query SQL, and cadence of the schedule.
Select a query run ID to navigate to the run details page and view query information.
Query run overview query-run-overview
The Query run overview provides information on individual runs for this scheduled query and a more detailed breakdown of the run status. This page also includes the client information and details of any errors that may have caused the query to fail.
The query status section provides the error code and error message should the query have failed.
You can copy the query SQL to your clipboard from this view. To copy the query, select the copy icon in the top right of the SQL snippet. A popup message confirms that the code has been copied.
Run details for queries with anonymous block anonymous-block-queries
Queries that use anonymous blocks to comprise their SQL statements are separated into their individual subqueries. The separation into subqueries allows you to inspect the run details for each query block individually.
Anonymous blocks are denoted through the use of a $$
prefix before the query. To find out more about anonymous blocks in query service, see the anonymous block document.
Anonymous block subqueries have tabs to the left of the run status. Select a tab to display the run details.
In the event an anonymous block query fails, you can find the error code for that particular block through this UI.
Select Query to return to the schedule details screen, or Scheduled Queries to return to the Scheduled Queries tab.