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:

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.