What do you need to do with it?

--Changed Query on 9-7-2016 to eliminate

-- "_backgroun_tasks"."link" edited out

SELECT "_sites"."id" AS "site id",

  "_sites"."name" AS "name",

  "_sites"."url_namespace" AS "url_namespace",

  "_sites"."status" AS "site status",

  "_background_tasks"."backgrounder_id" AS "backgrounder_id",

  "_background_tasks"."id" AS " background id",

  "_background_tasks"."created_at" AS "created_at",

  "_background_tasks"."completed_at" AS "completed_at",

  "_background_tasks"."finish_code" AS "finish_code",

  "_background_tasks"."job_type" AS "job_type",

  "_background_tasks"."progress" AS "progress",

  "_background_tasks"."args" AS "args",

  "_background_tasks"."notes" AS "notes",

  "_background_tasks"."started_at" AS "started_at",

  "_background_tasks"."job_name" AS "job_name",

  "_background_tasks"."priority" AS "priority",

  "_background_tasks"."title" AS "title",

  "_background_tasks"."processed_on_worker" AS "processed_on_worker",

  --"_background_tasks"."link" AS "link",

  "_background_tasks"."subtitle" AS "subtitle",

  "_background_tasks"."language" AS "language",

  "_background_tasks"."site_id" AS "site_id",

  "_background_tasks"."locale" AS "locale",

  "_background_tasks"."created_at" +0.25 * INTERVAL '1 DAY' AS "Time",

   CASE WHEN "_background_tasks"."progress" = -1 THEN 'Waiting'

       WHEN "_background_tasks"."progress" < 100 THEN 'In Process'

       WHEN "_background_tasks"."finish_code" = 0 THEN 'Success'

  ELSE 'Error' END AS "Backgrounder Status"

FROM "public"."_background_tasks" "_background_tasks"

LEFT OUTER JOIN "public"."_sites" "_sites" ON "_background_tasks"."site_id" = "_sites"."id"

WHERE "_background_tasks"."job_name" IN

('Increment Extracts', 'Reap Extracts', 'Refresh Extracts')

That'll get you what you need.  I don't remember where I stole the query from so I can't give credit for it.

Regards,
Gerardo

Hi Twinkle,

Here you go:

Tableau Server Insights (formerly Shareable Data Sources for Tableau Server)

Download the workbook TS Background Task. The workbook has the information you're looking for.

Regards,

Gerardo

You're welcome.

Regards,

Gerardo

Twinkle Bansal I would also recommend reading through Project Griffon blogs by Ravi Mistry. Really helpful in understanding the basics and building on top of it.