Note: The information in this article applies to SAS Visual Analytics, all versions.
If you create data queries for reports and explorations and you want them to reflect the most current data, you can set your data queries to run periodically so that they pick up the most recent data that was imported. This allows you to skip running the data query manually when the data changes. There are many different options to do this in terms of frequency.
To set up a data query schedule, you need to create a series of triggers. Each trigger is associated with a date and time. You can create a trigger that will run just once, multiple times, or at a regular interval.
To get started:
Running the query on specific dates and times
Let’s say you want to run a data query one time at a specific date and time in the future. This case is useful if you want the data query to run on specific dates or times that don’t fall into a regular interval. You can create as many ‘one time only’ triggers as you want. In this case, you will just need to set them up one at a time.
To run a query on specific dates and times:
You will see the event show up in the trigger list. Repeat the steps for any additional triggers that you want to set up. After you are finished making your schedule changes, make sure you click save icon in the workspace to save again.
Running the query at a regular interval
You can also set the query to run at a regular interval:
You will see the event show up in the trigger list. Repeat the steps for any additional triggers that you want to set up. After you are finished making your schedule changes, make sure you click the save icon in the workspace to save again.
Here’s some more information about creating the schedule for a data query.
If you modify a scheduled data query, you will need to resave the triggers. Otherwise, the schedule will no longer run. You do not need to set the triggers up again, however. Here’s the steps to get the schedule to run:
To permanently delete the schedule for a data query, you must use SAS Management Console. However, from SAS Visual Analytics, you can stop the data query from running:
Note: If you delete the last trigger in the list, and then you attempt to click OK to exit from the Schedule window, you will receive the following error message: "Cannot update the scheduled query. One or more events must be available." To bypass this, you must run the query one more time in order to exit from the window. Select Run now before clicking OK.
Here's some more information about scheduling data queries.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.