140 likes | 218 Views
wgScheduler. Generic Task Scheduling Application. What Does It Do. Automates any task that may be scripted using VBScript Triggers task execution (or issues reminder) at specified time The typical workflow may include the following: Query data sources: local databases, internet…)
E N D
wgScheduler Generic Task Scheduling Application
What Does It Do • Automates any task that may be scripted using VBScript • Triggers task execution (or issues reminder) at specified time • The typical workflow may include the following: • Query data sources: local databases, internet…) • Perform analytical tasks: Excel, R, QuantLib, any COM application • Publish reports: mail, upload, print… • Collection of tasks is saved in a single file and referred to as: session
Features • Schedule any number of tasks as part of a single session • Create separate sessions for different days/day workflow regimes • Have all session and task execution info in a single window • Enjoy color-coded Script Editor and comprehensive error reporting • Define session-wide constants and functions for use with any task • Generate reports, print, send mail • Download, upload, process RSS feeds • Automate Excel related tasks • Harvest Excel charts, tables, text and send as HTML formatted mail • Automate any COM compliant application • Play sound alerts • Include ready-to-use scripts from the script library • One-click documentation of the session • Detailed audit trail using optional logging facility
Task Properties • Task name • Active/Inactive • Only active tasks will be considered for scheduled axecution • Inactive tasks can be still executed manually • Scheduled time for execution • Action (execution mode): ‘Execute’, or ‘Remind’ • Allowed time for execution • When this time is reached, allow further execution, or abort the task • Can be set to ‘any’, or to a period between 5 seconds and 12 hours • Time of the next run • Time of the last run • Status • User defined short message generated from the script • Informs about the stage of execution, or the final result • Task script • Edited in the Script Editor
Session Properties • Session name • This is the name of the saved session file • Session constants • Variables and functions made available to all tasks in the session • Session constant script is executed before each task-level script • Schedule Inspection Timer • Sets time interval at which the session will be inspected • Available periods between 5 seconds and 1 minute • Active/Inactive • Activate Schedule Inspection Timer • Logging preference ON/OFF • Logging records each task execution in a log file • In addition, logging records each change of the task Status • List of tasks
Summary of Task and Session Properties Session Properties Task Properties Session Name C:\session1.sch Constants (script) Active/Inactive x Timer 30 Seconds Task Name B/S Simulation Active/Inactive Active Schedule 16:30:00 Logging ON Action Execute Tasks Allowed Time 1 minute Task 1: Prepare scenarios Next Run 16:30:00 Task 2: Extract accounts Last Run 2007-07-27 16:30:15 Task 3: B/S Simulation Status 1000 scenarios, OK Task 4: Mail reports Script (script) (…)
Main Window Finding a task in a session of many tasks Last schedule inspection Schedule inspection timer Logging status Today’s date Current time
Script Editor Number of lines in a script Current column Current line