Hi All, I automated SAS Enterprise Guide program by generating a VBScript and scheduled it with the task scheduler. This automated task should run daily, but somehow the task seems not stable. Most of the time it ran, sometimes (some random day, happen once a week or every two weeks randomly) it did not. I could not figure out the reason for it. The details: 1) I am using SAS server on Linux; 2) I used the windows task scheduler to schedule to VBScript at daily frequency. 3) In the SAS Enterprise code, I need to access data at SQL server and output the final table to SQL server. 4) even sometime the SAS code did not run, the task schedule still shows the task run successfully. See the attachement (today the code did not run, but the task still show it runs successfully). SSo what's the possible reason for that? SAS to SQL connnection is not stable? Thanks, Jade
... View more
