Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Batch File that Launches a URL on Tableau Server

aehrenwo
11 - Bolide

I have a workflow that is supposed to launch a batch file that goes to a specific URL For tableau to force a refresh of the data connected to workbook. 

 

If I run the batch file locally on the server it launches Chrome fine. 

 

@echo off
Title Start and Kill Internet Explorer
Mode con cols=75 lines=5 & color 0B
echo(
echo                     Launching Dashboard...
Start "" "chrome.exe" "https://tableauserver.ourcompany.com/t/HCC-Risk/views/GTD_AutoRefresh/Summary?:embed=yes&:linktarget=_self&:refresh"
:: Sleep for 10 seconds, you can change the SleepTime variable
set SleepTime=30
Timeout /T %SleepTime% /NoBreak>NUL
Cls & Color 0C
echo(
echo              Killing Internet Explorer Please wait for a while ...
Taskkill /IM "chrome.exe" /F

However, when the workflow runs through the web interface on the server it says it ran successfully but I have no way to validate that the browser is opening as it isn't happening live on Server.  Is there an easier way to accomplish this? 

 

I need this URL to be opened every 12 hours. 

 

Regards,


Adam

2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @aehrenwo

 

A couple of thoughts here...

 

  1. You can use the data last refreshed field in a Tableau workbook to see if the data was actually refreshed or not
  2. If your running a batch file, why are you using a workflow and not using windows scheduler?
aehrenwo
11 - Bolide

I actually just started playing around the task scheduler. I was having trouble figuring out where it saved the task once I created it.  I think I am good to go. 

 

But thank you also for the option to check the refresh data on Tableau directly.