I have scheduled jobs that run on Viya release 20230209.1675986674210 on MS Azure. Sometimes the "status" shows in "SAS Environment Manager \ Jobs and Flows \ Monitoring" as "Timed Out", as opposed to "Failed". Usually if the status shows as "Failed", I see the "ERROR:" line in the SAS log. However, when the status has shown as "Timed Out", the SAS log hasn't contained any errors and the job looks to have executed successfully. The scheduled job performs read queries on an MS SQL database and also writes to the SQL database. What does the scheduler status message of "Timed Out" mean?
Thanks for those who have replied to my question. After months of intermittently seeing the "Timed Out" message on the Viya scheduler with no error messages or adverse effects in the log (results of the scheduled job are produced and as expected), I surmise that the "Timed Out" message gets triggered when an SQL query takes longer to return results than Viya thinks it should. There are other times with I get the "Timed Out" message and NO log is created on the scheduler - those are true issues because the scheduler never picked up the job to execute it. But in the scenario I was asking about, no harm, no foul. The message is simply a nuisance one.
I also have issues with "Timed Out". In my case we didn't have one huge SQL-query but many few. That made it possible to work around the problem by splitting the job into two.
The status "Timed Out" should really be addressed as a bug or at least documented.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!