KNOWLEDGE BASE

How To Check The Status Of Jobs With The Tableau Server Repository Using Custom Admin View


Published: 08 Jun 2021
Last Modified Date: 09 Jun 2021

Question

How to check the status of jobs from the Tableau Server Repository (Workgroup Database) using customer administrative view?

Environment

  • Tableau Server
  • Custom Administrative Views

Answer

Create a calculated field to check the status of e.g. backgrounder jobs, as shown in the following example.
For more information about the tables and views in the "workgroup" PostgreSQL database, see About the Tableau Server Data Dictionary.

--------------------
IF [progress] == -1 THEN
  "Pending"
ELSEIF [progress] < 100 THEN
  "In Process"
ELSEIF [finish_code] == 0 THEN
  "Success"
ELSEIF [finish_code] == 2 THEN
  "Cancelled"
ELSE
  "Error"
END

--------------------
Did this article resolve the issue?