Hello Sukhdeep Kaur,
First steps: Have you tried killing the process, un-scheduling, re-scheduling it?
Let me know if it solves your problem
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Yes, I always end the task in this case and rerun it again which is a temporary solution.
There are other tasks as well which shows similar behavior sometimes which are scheduled at different time. so i think re-scheduling won't work here
Another troubleshooting step would be to investigate the network in which the jobs are running. As it sounds like you have verified there is nothing within the Tableau Server that is catching the script.
Thanks for looking into this. Could you please explain what should i investigate in network.?
Does the extract always succeed? Do emails get sent out? Where does the process normally fail when it doesn't work?
scenario 1) Task having extracts refresh.
Yes extract succeed but email did not shoot out.
scenario 2) Task do not have extracts connected. Task contains the workbook having live connection.
In this case there is no extract refresh and task remains in running status for 1 hour.
I don't know Powershell so my help is limited.
1. Sounds like a non-Tableau issue.
2. Credentials need to be embedded in the workbook.
It could be a script issue. For example, is it waiting for a response?
Thanks you so much for looking into this . Tom W has suggested to enable logging in the script. So when it runs, i can check logs to see which part of the script is taking long to run.
Let us know your results and how you fixed it. Your answer could help others that run into a similar situation