This is awesome Mark! I have been manually prioritizing based on time and it is a huge pain when you have thousands of extracts to update.
thanks Mark! I never knew of the sorting feature, is it new?
I still find a backgrounder utilization viz very useful for identifying offending sites Re: Viewing Tableau 9 Background Tasks Queued Getting users with long running jobs to use a Serial rather than Parallel schedule also helps to stop them hogging all the backgrounders.
1 of 1 people found this helpful
I am on v10.0 with about 3,000 extracts per day and 40 backgrounders. tabadmin set backgrounder.sort_jobs_by_run_time_history_observable_hours must be a v10.0 new feature. I have not seen this set option at v9.2 admin guide or v9.3 admin guide but it shows the 1st time on v10 admin guide. I have not seen Tableau advertises this feature anywhere in official v10 new feature list. I think that this is another great big brother v10 new feature similar as Desktop license reporting. One more good reason to upgrade to v10 if you have not done so yet.
60 backgrounders on V10.2 now with about 6,000 extracts/day
80 backgrounders on V10.5 handles 15,000 extracts/day with avg 10 min delay at peak hour
Where can I find the technically implementation of the script to set this automatically?
The key trick is to update tasks.priority (tasks is Postgre table name, priority is the column name) to whatever priority you wanted.
has anybody ever checked as well the built-in heuristic feature of Tableau? --> the default config YML file has some hidden parameters which can be set?
# Some average run time heuristic for different background jobs, used when calculating background job's jobRank
# the heuristic numbers below are based on background job data on 10ay before 08/08/2017 9:00:06
# Days that objects are allowed to be in the datasource_events table before removing them.
#Controls: whether to calculate background job rank or not when queueing a job
#And whether to update task run time when recording a job as finish
sorry, just read the full article from Mark: Scaling Tableau (2/10) - Set Extract Priority Based on Duration - Silicon Valley Enterprise Tableau User Group --> awesome explanation!
Also interested in the code as I was planning on writing something similar in python.