Search the Community
Showing results for tags 'scheduler'.
-
I wrote the following script. I have similar scripts to open internet explorer and excel when the user is not logged in and they work fine. The following script which opens an SSIS package and execute it is working fine when the user is logged in but stop working when the user is logged off. It stops after opening the SSIS package. I dont know why controlsend is working in the other two scripts but not in this one. Please help. ShellExecute("C:\Users\xyz\Desktop\exescripts\PackageToUploadDataToSqlServer.dtsx") sleep(5000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(500) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(500) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(500) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(500) ControlSend("Execute Package Utility", "", "", "{ENTER}") sleep(50000) ControlSend("Package Execution Progress", "", "", "{TAB}") sleep(1000) ControlSend("Package Execution Progress", "", "", "{ENTER}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{TAB}") sleep(1000) ControlSend("Execute Package Utility", "", "", "{ENTER}") sleep(1000) Exit
-
This script will get all Scheduled tasks as defined on a system There are basically 3 functions in this small udf: _TaskGetFolders() will return an array of all folders as from a given Scheduler Library folder, recursively. $aFolders will have to be declared before the function is called, I am not sure if there is a better method to avoid having to declare the array outside of _TaskGetFolders()... _TaskListAllDetailed() will return a detailed array of all tasks in a given task folder, recursively. This function is using _TaskGetFolders() for the recurse option. _TaskListToText() will create a formatted output of scheduled tasks as returned to the above array. The script is complementary to taskplanerCOM.au3 by Allow2010. The example shows all folders in the Scheduler Library All scheduled tasks in root (with formatted output) All scheduled tasks on the system Scheduled tasks Windows Defender if available _TaskListAllDetailed.au3
- 11 replies
-
- scheduler
- task scheduler
-
(and 1 more)
Tagged with: