-
1. Re: How can you check if a background task has run successfully from command line?
Lester Anciro Sep 9, 2013 6:29 PM (in response to Roberto Arnetoli)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 ErksonSep 10, 2013 8:05 AM (in response to Roberto Arnetoli)
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?
Roberto Arnetoli Sep 10, 2013 10:17 AM (in response to Lester Anciro)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?
Roberto Arnetoli Sep 10, 2013 10:18 AM (in response to Toby Erkson)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 ErksonSep 10, 2013 11:22 AM (in response to Toby Erkson)
2 of 2 people found this helpful -
6. Re: How can you check if a background task has run successfully from command line?
Roberto Arnetoli Sep 19, 2013 10:00 AM (in response to Roberto Arnetoli)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