I think you can just put
at the end of the command line to see if it successfully finished running your tabcmd batch file.
2 of 2 people found this helpful
I would say "no". Read this: http://onlinehelp.tableausoftware.com/current/server/en-us/help.htm#adminview_postgres.htm
Maybe you can figure something out from here. Let us know if you're successful and how you did it.
Thanks Lester. I am already doing this using the tabcmd command in a batch file, but what the "FINISH" tells you is that Tableau has correctly scheduled the extract refresh and not that it has executed it correctly.
Thanks Toby. I'll give it a try and let you know.
1 of 1 people found this helpful
The information you sent me lead me to the solution.
I have activated the access to Tableau's database as suggested and used the _background_tasks table with a query similar to the one below from the command line (or a .BAT file)... obviously replacing HOSTNAME with your hostname ... and send the output to myLogFile.txt
psql -h HOSTNAME -p 8060 -d workgroup -U tableau -c "SELECT backgrounder_id, id AS task_id, created_at, started_at, completed_at, finish_code, progress, title AS workbook FROM public._background_tasks WHERE job_name = 'Refresh extracts' AND created_at >= CURRENT_DATE ORDER BY created_at;" > myLogFile.txt