Zeta Scheduler

• Download latest binary package (from external server)
• Download Source code

Click for large image

Introduction

Zeta Scheduler (ZS) is an application that helps you in starting tasks at predefined times and with various dependencies. In contrast to the Windows Task Scheduler, ZS has more/other features that makes it more flexible, providing features that are not available otherwise.

History

We started developing ZS for a client after he found no state-of-the-art replacement for a tool called "Norton Scheduler" which dated from around mid 1990's. We found no other tool available on the market that matches the features of Norton Scheduler and the new requirements of our client.

Therefore we developed ZS together with our client.

Current state of the tool

Currently, Zeta Scheduler is in public beta test.

This means:

• You can use it free of charge.
• The installation process requires you to perform manual steps.
• The documentation is spare.
• Bugs may still exist.
• Some features are still missing.

Overview

ZS consists of two applications: An application called Zeta Scheduler Manager (ZSM) and an application called Zeta Scheduler Scheduler (ZSS).

ZSS is a console application that is running on each computer that you want to run scheduled tasks. ZSM is a Windows GUI application that is running on one computer to manage all computers running ZSS.

In addition, a central Microsoft SQL Server database is being accessed by all ZSS and ZSM instances to read and write configuration settings.

Features

Schedule modes

ZS allows for defining tasks that can execute either depending on date/time settings or depending on each other. The follown modes are supported:

• Run once at a given date.
• Run yearly at a given date.
• Run monthly at configurable days at a configurable time.
• Run daily or weekly at given weekdays at a given time.
• Run hourly every n hours.
• Run at a variable dates/times. This is a highly configurable mode, where you can set weekdays, month days, and multiple hours and minutes independently.
• Run at system start, n minutes after the computer started.
• Run dependent on another task. This mode allows to chain multiple tasks, allowing to start a certain tasks only upon success or failure of a previous task.

In addition you can configure a task to not run on public holidays (which are configurable, too).

Notifications

Each task can be configured to generate notifications upon successful finish and/or when finished with errors. Notifications can be sent to any of the following targets:

• By e-mail to one or multiple receivers.
• A log file.
• A database table. (To e.g. evaluate later with 3rd party tools).
• The window event log.

Each notification can be configured to be sent to multiple targets simultaneously with configurable notification texts.

Jobs

The concept of a "job" contains all the definitions of an actual task to be scheduled. A job is contained in a global repostitory of jobs, allowing to easily assing one job to multiple tasks (optionally on different computers) thus simplifying the creation and assignment of tasks.

A job contains the following major settings:

• Name and category - Helps in categorizing and quickly finding jobs.
• Program file, command line, startup folder - The core definition of the application/script to execute.
• Result ranges - To specify the exit codes that you consider as "success" and as "failure".
• User login information - To run the process as another user.

Computers

A "Computer" identifies a machine that is running the ZSS application. In the central ZSM management application you can create an arbitrary number of computers and assign tasks to it.

Settings fo a computer contain:

• An IP address or host name.
• A friendly name.
• A description.
• A flag to activate/deaktivate all tasks.

Placeholders

For most settings (like job definitions or notification settings), you can use placeholders that are expanded during runtime. This enables you to minimize hardcoding of information, making the application easily transferable to other systems.

Some example placeholder among the more than 70 placeholders include:

• Environmental information like computer name, environment variables, operation system version, IP address.
• Global information like current date or time.
• Path information like current ZSS file and folder path.
• Task information like name or last result.
• Job information like ID or user name.

Various other features

• Detailed result history of tasks that ran in the past. The history is stored in the database so that you can use 3rd party tools to further process the results.
• Ribbon UI for easy usage.
• Great, fast, responsive support from friendly support engineers.

Installation

Preface

This section assumes that you are familiar with:

• Basic Microsoft Windows Server 2003/2008 operating system administration.
• Microsoft .NET Framework 3.5 administration.
• Microsoft SQL Server 2005/2008 administration.

Requirements

To successfully set up the ZSM and the ZSS components you need the following prerequisites:

• Microsoft Windows Server 2003/2008, Microsoft Windows XP, Microsoft Windows Vista or Microsoft Windows 7.
• Microsoft.NET Framework 3.5.
• Microsoft SQL Server 2005/2008.

The setup components package consists of:

• ZIP archive with the server components, consisting of a complete ASP.NET application (with ASPX files, DLLs, configuration file, etc.).
• An SQL Server database backup of the Zeta Scheduler database with the structure but no data.
• This document.

Steps

Download and run the deployment setup

First, download the deployment setup and run it. The deplyoment setup brings all the required files to your local computer (to the desktop by default) but does not actually install any components. This must be done manually during the beta stage.

After you run the deployment setup, you find the following child folders in the installation folder (default: "C:\Users\YourLogInName\Desktop\Zeta Scheduler"):

• "Manager" - The executable for the ZSM application.
• "Scheduler" - The executable for the ZSS application.
• "Database" - The Microsoft SQL Server 2005/2008 script to create the objects of the ZS database.

Install the database

In order to install the database, follow these steps:

1. Select a Microsoft SQL instance that is accessible by the computer where you plan to install the ZSM application as well as by all computers that will be running the ZSS application.
2. In Microsoft SQL Server Management Studio, create a new Database "ZetaScheduler".
3. Next, open and run the script "ZetaScheduler.sql" in the "Database folder that was delivered by the deployment setup.

You have successfully configured the database structure. Please ensure that you add the new database to your maintainance plan to ensure it will be backed up.

Configure the ZSM management application

The ZSM management application is your central GUI for configuring and administering all ZSS instances. To install, perform the following steps:

1. Move content of the "Manager" folder from the deployment setup to an appropriate location, e.g. "C:\Program Files\Zeta Scheduler Manager".
2. Open the "zsm.exe.config" configuration file with an (XML) text editor (e.g. Notepad or another text editor like "Notepad++" - but not with e.g. Wordpad or Microsoft Office Word, since the content will be rendered unusable).
3. Adjust the connection string to point to your previously installed Microsoft SQL Server instance.
4. Optionally, adjust the "zsm.logging.config" file that define how/whether internal logging should be performed. See the log4net website for a complete set of available logging configuration settings.

The default connection string to adjust in item 4.) reads:

connectionString="data source=EnterYourDBServerHere;
    initial catalog=EnterYourDatabaseHere;
    Integrated Security=False; 
    User ID=EnterYourUserIDHere; 
    Password=EnterYourPasswordHere"

If you are unsure how to exactly form your connection string, you may want to visit the website ConnectionString.com which contains various examples.

Deploy the ZSS scheduler application

for each computer where you want tasks to be scheduled with ZS, you have to copy and configure an instance of the ZSS executables:

1. Copy content of the "Scheduler" folder from the deployment setup to an appropriate location, e.g. "C:\Program Files\Zeta Scheduler".
2. Open the "zss.exe.config" configuration file with an (XML) text editor.
3. Adjust the connection string to point to your previously installed Microsoft SQL Server instance.
4. Optionally, adjust the "zss.logging.config" file that define how/whether internal logging should be performed.
5. Create an entry in the Windows-built-in Task Scheduler pointing to "zss.exe" and configure it to "run on system startup". This ensures that the core scheduling engine is always present. (We will replace this with an actual Windows service in future versions).

Repeat the steps 1. to 5. for each computer where you want tasks to be executed with ZS.

Troubleshooting

If you have errors during installation, check the following items:

• Inspect the Windows Event Log for detailed error messages.
• Inspect the log files that the ZS components write.
• Visit the official support area and ask for further assistance or simply post your question in the comments section at the very end of this article.

Configuration

Once you have successfully installed the database, ZSM and the ZSS instances, you have an empty installation that you have to configure before actually running.

This chapter tells you how.

The ZSM main window

The main window of the ZSM management application consists of a ribbon menu at the top of the window. Use the ribbon menu items to perform various actions.

Below the ribbon area is the main tree list that displays all computers, tasks and child tasks. The columns from left to right display information about the state of a task and other useful values.

On the left side of each node in the main tree list, a colored square icon is being displayed which shows the cumulated state of an element and all child elements in an easy-to-remember traffic light color range:

• Gray icon - The computer/task contains no result (i.e. no tasks or tasks that never run).
• Red icon - The element (or a child element) ran and exited with an exit code that is being interpreted as "failure". An element is red as soon as one child element is red, even if other child elements are green.
• Green icon - The element (and all child element, if any) ran and exited with an exit code that is being interpreted as "success".
• Yellow icon - Some child elements exist that are green and some that are gray.

Create a computer

Create a new root element "computer" for each computer where you have a ZSS instance running:

1. On the main ribbon, click "Add computer".
2. Enter the host name or the IP address of the computer.
3. Give the computer an meaningful name, e.g. the host name.
4. Optionally enter remarks for your own comfort.

Define jobs

Jobs are the building blocks for the actual tasks. Define one or more jobs to later use them when defining tasks. Each job can be used by multiple tasks.

1. In the main ribbon click "Jobs".
2. The jobs window opens. Click "New" button to add a new job.
3. Enter a name for the job to identify it later.
4. Enter a program's full path to program to start. Use placeholders to make it usable on multiple computers even with slightly different configuration. Enter e.g. "$(SpecialFolder.System)\notepad.exe" to point to the Windows notepad application.
5. Specify optionally arguments and a startup folder path.
6. Tell ZS which exit codes from the program to interpret as "success" and which as "failure". Usually this information depends on the program you actually plan to run and is provided by the manual for the program. As its vendor for further details.
7. Optionally configure a user (user name, password, domain) to start the program with. If you omit this information, the program will be started with the same user context as the ZSS application is running.

Repeat those steps to add all required jobs. Of course you can define jobs later as you need them.

Define notifications

Notifications enable you to configure whether/how the successful/erroneous exit of a task will be notified. You define notifications in a global repository and assign them later to the actual tasks to run.

To define a notification:

1. In the main ribbon click "Notifications".
2. The notifications window opens. Click the "New" button to add a new notification.
3. Enter a name for the notification to identify it later.
4. Configure which notifications will be sent out to which destinations.
5. Configure the notification texts that will be sent out.

To configure global notification settings:

1. In the main ribbon click "Notifications".
2. The notifications window opens. Click the "Setting" tab page to show all available notification configurations.
3. Enter the e-mail (SMTP) server settings and the log file settings.

Please note that the notification settings are being used for all computers running the ZSS application. This means that when e.g. configuring an SMTP server you have to ensure that all computers are allowed to send e-mail messages through this server.

Define tasks

After you have defined your jobs which serve as the base for the tasks, you can start adding tasks.

Since tasks can be added both to computers as root tasks and to other tasks as child tasks, it is important which element you select in the main window tree list.

Adding root tasks to computers

To add a root task to a computer, perform the following steps:

1. Select the computer in the main window by left-clicking it.
2. In the main ribbon click "Add task".
3. Give the task a name to identify it later.
4. Select a predefined job from the list. This job is executed for the conditions you configure in the task. If you want to add a new job, click the "Jobs" button.
5. Click the "Scheduled times" tab page.
6. Enter/select the scheduling times of the task.
7. Optionally, click the button "Save and recalculate" to verify the actual schedule dates that the task will be executed.
8. Click the "Further settings" tab page.
9. Optionally configure notifications to be sent out upon successful or erroneous exit of the program to run.

Repeat the above steps for all root tasks you want to add.

Add child tasks to tasks

To add a child task to an existing task, follow these steps:

1. Select the task in the main window by left-clicking it.
2. In the main ribbon click "Add task".
3. Give the task a name to identify it later.
4. Select a predefined job from the list. This job is executed for the conditions you configure in the task. If you want to add a new job, click the "Jobs" button.
5. Click the "Scheduled times" tab page. For child tasks, only one option "Dependent" is available.
6. Configure the scheduling time.
7. Optionally, click the button "Save and recalculate" to verify the actual schedule dates that the task will be executed.
8. Click the "Further settings" tab page.
9. Optionally configure notifications to be sent out upon successful or erroneous exit of the program to run.

Repeat the above steps for all child tasks you want to add. Please note that you can nest tasks indefinitely.

Compiling the source code

In order to compile and run the provided source code by yourself, the following requirements must be present:

• Microsoft Visual Studio .NET 2008.
• DevExpress DXperience WinForms components.

You also need to set up and configure a database and adjust the ZSM and ZSS configuration files just as previously described in the "Setup" section.

The used Zeta Enterprise Library is also available in a separate article.

Epilog

In this article I've introduced a replacement/extension to the Windows Task Scheduler.

When voting, please notice that I put my article in the "Utilities" section, so I assume it is safe to not post any source code explanations in the article itself. Thanks.

Source code size/location

A last word about the source code: Since the source code is approx. 30 MB, I decided to put it on an external server since it exceeds the allowed size limit of CodeProject.com.

The reason for the large size is that the download contains DLLs to allow for successful compilation of the Visual Studio solution.

So my decision was to prefer a compilable code over size. If you disagree, please comment and I will provide an alternative source download.

History

• 2009-11-18 Minor fixes.
• 2009-11-16 First release on CodeProject.com.

You must Sign In to use this message board.

FAQ    Noise Tolerance Very HighHighMediumLowVery Low   Layout Expand Posts & RepliesThread ViewNo JavascriptNo JS + Preview   Per page 102550

Msgs 1 to 9 of 9 (Total in Forum: 9) (Refresh) FirstPrevNext

Nice program Dinesh Mani 20:46 18 Nov '09   It is a very good solution and what is interesting here is that I'm in the same state of satisfaction with the default Windows scheduler and have started work on a small stand alone app that would carter my scheduling needs. I was wondering if I should use a Wind service or a console app in the background to take care of triggering the jobs. I couldn't come to any outright conclusions but my heart was more inclined towards using a Win service [mainly because of the learning I could get, since this would be the first time I would be doing it]. I'm sure your team would have had the same dilemma during the design phase and you would have concluded on console app after a detailed analysis / discussion. It would be great if you could share your reasons for and against both approaches, if you ever hit upon this dilemma. BTW, 5 * from me! Sign In·View Thread·PermaLink 5.00/5 (1 vote) Re: Nice program Uwe Keim 21:00 18 Nov '09   Thank you very much! We went to the Console version first, since it is easier to develop and debug. Customer want's service So the idea is to later move it to a service when the application has proven to be stable and functional. Cheers Uwe • My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now! Sign In·View Thread·PermaLink Re: Nice program Dinesh Mani 21:15 18 Nov '09   Ok! I also think that using a Win service would make more sense in your case since you would need to run the job irrespective of the user who has logged in. It would be easy to achieve this using a service than a console app. BTW, would it be ok if I reuse some of your components for my app? I won't be making any product out of my work but would be using it only for personal use on my home PC? Might share it with my friends and family based on the result. Sign In·View Thread·PermaLink Re: Nice program Uwe Keim 21:26 18 Nov '09   Sure! I would love to see people using my work; after all this is the idea of CodeProject.com, at least for me. Thank you! • My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now! Sign In·View Thread·PermaLink Re: Nice program Dinesh Mani 21:49 18 Nov '09   Thank You! Sign In·View Thread·PermaLink Nice program, some improvement suggestions f r i s c h 23:36 15 Nov '09   Hey there, the program looks nice, haven't tested it though. What would be really cool in the case of local schedules usages would be to save the data not in an sql db but either in a simple access db or what would be better in a xml-file via serialization. Also it would be cool if you could also give .net-DLL applications as scheduled process which would implement an interface provided by your app containing a simple Run-Method and a Config-Method which on the dll-side could be for configuring the steps or executing the necessary steps e.g. a user developed dll which backups several files from a to b. Sign In·View Thread·PermaLink 5.00/5 (1 vote) Re: Nice program, some improvement suggestions Uwe Keim 23:37 15 Nov '09   Great suggestions, thank you very much! • My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now! Sign In·View Thread·PermaLink Re: Nice program, some improvement suggestions sam.hill 5:47 16 Nov '09   I agree. Sign In·View Thread·PermaLink Re: Nice program, some improvement suggestions Uwe Keim 6:33 16 Nov '09   Thank you very much! I'll try to include your additions ASAP. • My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now! Sign In·View Thread·PermaLink

Last Visit: 11:43 9 Feb '10     Last Update: 11:43 9 Feb '10 1