Using Scheduled Queries

Once you create a query that works for you, you can schedule it to run on a regular basis. Queries can be run on the fly as temporary live queries, or you can create and schedule queries to run on a regularly scheduled basis, with the results sent to an application or data store of your choice. The schedule increments run from 5 minutes to 30 days. For example, you can schedule a job to run every 5 minutes for 72 hours; or every 24 hours for 72 hours (that is, once a day for 3 days).

To schedule a query:

  1. Create the query you want to have run on a scheduled basis and click Schedule Query. The Schedule Orbital Query popup window opens.

    The default schedule is to run the job once in 24 hours.

  2. Define the query's schedule by providing the parameters for the following popup elements.

    1. Type the name of the query in the Name field. This is the name of the query's schedule that will be listed in the Results page. You do not have to provide a name to the query's schedule. If you wish, you can choose to use the default schedule name.

    2. Set the query schedule's frequency using the Every dropdown. Click the down arrow on the right side of the Every dropdown, then select the appropriate value. Refer to the top paragraph of this topic for a definition of frequency.

    3. Set the query schedule's duration using the For dropdown. Click the down arrow on the right side of the For dropdown, then select the appropriate value.

    4. Select the Run once toggle if you wish to have the query's schedule run once in the next 24 hours. Selecting this toggle will cancel any values you set for the Every and For dropdowns.

    5. Use the Remote data store dropdown to select the remote data store source where the query results will be sent during its run. If you wish to select more than one remote data store sources, refer to Setting Up Remote Data Stores page. Also, refer to the Remote Data Store Errors section in the Remote Data Store topic for more information on Remote Data Store Errors.

    6. Select the Save empty results toggle if you wish to include query results where the endpoint has not returned any result values.

    7. Use the Add Remote Data Store link to add a new remote data store, if the data store or stores you need are not listed in the Remote Data Store dropdown. Clicking this link will open the Settings page and display the Remote Data Stores page. Refer to The Remote Data Stores Page for more information.

    8. Select Go to Result toggle to open the Results page and display the query results for that job once you have started the query run. This has the benefit of immediately viewing the results instead of having to migrate to the Results page, then find and select the results from the list of jobs.

  3. Start or abandon the query's schedule.

    • Click Schedule to begin running the query's schedule. Clicking this button with remove the Schedule query popup from the screen and start the query. Once you have started the query, you can see it listed on the Results page.

    or

    • Click Cancel to abandon the query's schedule. Clicking this button will remove the Schedule query popup from the screen and discard any parameters you might have set.

     

How to Select Multiple Remote Data Stores

There may by times when you wish to sent the results of a query to more than one remote data store. In order to assign more than one remote data store to a query's schedule:

  1. Click the Remote Data Store dropdown to expand it.

  2. Navigate to the desired remote data store listing.

  3. Select the desired remote data store so that it is displayed in the Remote Data Store dropdown's field.

  4. Expand the Remote Data Store dropdown again.

  5. Navigate to the next desired remote data store listing and select it.

  6. Repeat until you have selected all of the required remote data stores.

In order to delete a remote data store listing, click on the X beside the data store's name.

More Info