Scheduled jobs must sometimes be set as high or low priority items.

A job that is submitted with higher priority has a better chance of being executed and assigned resources more quickly than a job with lower priority.

Job Priority

2 (Very High)

1 (High)

0 (Default)

-1 (Low)

-2 (Very Low)

These settings can help you prevent normal priority jobs from running in parallel with the high priority jobs.

  1. Navigate to Data Workbench > Queries.

  2. Select the query for which you want to set priority.

  3. Select the ellipsis.


  4. Select Edit query settings.


  5. Set the Priority.


  6. Select OK to save changes and exit.

Optionally, from the command line you can use:

td query -P <priority> <query_id>

Priority

Priority Value

Example

Normal

0


very low

-2

$ td query -P -2 <query_id>

low

-1


high

1

$ td query -P 1 <query_id>

very high

2


  • No labels