-
1. Re: How can you check if a background task has run successfully from command line?
I think you can just put
echo "*FINISH*"
at the end of the command line to see if it successfully finished running your tabcmd batch file.
-
2. Re: How can you check if a background task has run successfully from command line?
Toby Erkson
Sep 10, 2013 8:05 AM
2 of 2 people found this helpfulI 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.
-
3. Re: How can you check if a background task has run successfully from command line?
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.
-
4. Re: How can you check if a background task has run successfully from command line?
Thanks Toby. I'll give it a try and let you know.
-
5. Re: How can you check if a background task has run successfully from command line?
Toby Erkson
Sep 10, 2013 11:22 AM
2 of 2 people found this helpfulI think the '_background_tasks' view will be your main source of info:
-
6. Re: How can you check if a background task has run successfully from command line?
1 of 1 people found this helpfulThanks Toby!!
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
