Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Modules: Scheduler Utility

Author(s)
Dev Ashish &
Terry Kreft&
Ken Getz

INFORMATION PROVIDED IN THIS DOCUMENT AND THE SCHEDULER UTILITY ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED. THE USER ASSUMES THE ENTIRE RISK OF RUNNING THIS SOFTWARE.

1999-2002, Terry Kreft and Dev Ashish.

The INI Class Modules were written by Ken Getz.
-2002 MCW Technologies, LLC
All rights reserved.

The Scheduler can be used to run applications at specified time of day.

    Download Scheduler version 1.04.0027
  See Screenshot 1
See Screenshot 2

 

You can run the utility by double-clicking on the Scheduler.Exe file.  The source code for this Visual Basic 6 project is included and can be viewed using Notepad or any other text editor.

Setup
--------

Since Scheduler was written in Visual Basic 6, you will need to either have the runtime libraries or VB6 itself installed on your machine. The runtime files can be downloaded from this link.

How to schedule jobs
-----------------------------

    The Scheduler utility reads the schedule information from the SCHEDULER.INI file. It MUST be present in the same folder as Scheduler.exe. This file can be modified manually in Windows or through the screen provided for this functionality in Scheduler. The structure of the INI file is as follows:

[Your Description For The Job]
CommandLine = 
WindowMode =
Monday = 
Tuesday = 
Wednesday = 
Thursday = 
Friday = 
Saturday = 
Sunday = 
HasRunToday=False

CommandLine: The command line must be valid and must include the full path to the application's executable file as well. That is, if you're trying to start an Access database located as C:\My Document\SomeDB.MDB, the command line must read (all in one line)

CommandLine= C:\program files\Microsoft Office\Office\MSAccess.exe C:\My Document\SomeDB.MDB

WindowMode: This option is the same as the WindowStyle argument of the Shell function and uses the same contant values. 

DaysOfWeeek: The next seven lines allow you to set specific times when you want the app to run. To omit a day, don't enter any values for that item. For example, if you want to run an app Mon-Wed at 5 PM, this section would read as

Monday = 5:00:00 PM
Tuesday = 5:00:00 PM
Wednesday = 5:00:00 PM
Thursday = 
Friday = 
Saturday = 
Sunday = 

HasRunToday: This item is used internally by the Scheduler and should not be modified by the users.

AppSettings.INI
-----------------------

This file is used internally by the Scheduler and should not be modified by the user.

If the "Create Log" option is checked in the main screen and a path for the log files is selected, the Scheduler will create an entry for each application it runs automatically in a text log file. The log file name is derived from the day's date and is in the format "log-dd-mm-yyyy.txt". 

The Scheduler will create a new log file for each day and entries for all applications started on a particular day will reside in the log file corresponding to the particular date. Typical entries in the log file will contain a new section whose name will correspond with the time of day, and an entry specifying the application description which was successfully launched. For example,

[3/3/99 1:07:21 PM]
Testing db="Testing db" was executed successfully.
[3/3/99 1:11:17 PM]
Testing db="Testing db" was executed successfully.
[3/3/99 1:13:10 PM]
Testing db="Testing db" was executed successfully.

Contact Information
---------------------------

If you have any comments or suggestions then you can contact me, Terry Kreft or you can contact Dev Ashish.


1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer