D
DanFlak
Guest
Windows 7 Professional.
I have a three-tiered system for the task scheduler.
1. I schedule the task
2. The task opens an Excel Script file that has an ON Open event.
3. The script file opens a target workbook and runs a macro in it.
I've been using this system for a couple of years now on multiple reports, but now it is failing. I've run three test cases:
Case 1 is the default. With the computer on, but I'm not logged in. Yes, I do have "run whether user is logged in or not" checked and I do have the correct credentials. In this case, the task scheduler launches the script but nothing happens. It does not launch the target workbook and the task fails immediately (or within one minute of launch) with "The last run of this task was terminated by the user." The target workbook should run for at least an hour. The script remains running until I log in and kill it.
Case 2 is that I launch the task scheduler, select the task and select run. In this case, the system works as designed: the script launches, it runs the macro in the target workbook, the macro completes, the target workbook closes and the script closes and the task gets a status of "The operation completed successfully."
Case 3 is that I lock my workstation but do not log out and I wait for the scheduled time. I get the same results as Case 1.
The bottom line is that the task scheduler does not run when scheduled. It can only run if I launch it manually which sort of defeats the purpose of the scheduler.
I even went so far as to delete the task and the script and rebuild them with identical results.
I had some issues with tasks that showed that they were ready, but over on the right side it stated "This task is currently running." I got this message even after a reboot. I don't know if this is related and I am not seeing at the moment.
I do have tasks that do run successfully, but they have not been changed since before I started having this issue. It seems to be only with recently-changed or recently-created tasks that I have the problem.
Continue reading...
I have a three-tiered system for the task scheduler.
1. I schedule the task
2. The task opens an Excel Script file that has an ON Open event.
3. The script file opens a target workbook and runs a macro in it.
I've been using this system for a couple of years now on multiple reports, but now it is failing. I've run three test cases:
Case 1 is the default. With the computer on, but I'm not logged in. Yes, I do have "run whether user is logged in or not" checked and I do have the correct credentials. In this case, the task scheduler launches the script but nothing happens. It does not launch the target workbook and the task fails immediately (or within one minute of launch) with "The last run of this task was terminated by the user." The target workbook should run for at least an hour. The script remains running until I log in and kill it.
Case 2 is that I launch the task scheduler, select the task and select run. In this case, the system works as designed: the script launches, it runs the macro in the target workbook, the macro completes, the target workbook closes and the script closes and the task gets a status of "The operation completed successfully."
Case 3 is that I lock my workstation but do not log out and I wait for the scheduled time. I get the same results as Case 1.
The bottom line is that the task scheduler does not run when scheduled. It can only run if I launch it manually which sort of defeats the purpose of the scheduler.
I even went so far as to delete the task and the script and rebuild them with identical results.
I had some issues with tasks that showed that they were ready, but over on the right side it stated "This task is currently running." I got this message even after a reboot. I don't know if this is related and I am not seeing at the moment.
I do have tasks that do run successfully, but they have not been changed since before I started having this issue. It seems to be only with recently-changed or recently-created tasks that I have the problem.
Continue reading...