SQLScheduler

SQLScheduler is a fully functional client/server application written in C# that allows administrators to schedule various SQL jobs for SQL Server Express and other versions of SQL Server.

Features:

• Supports all versions of SQL Server 2000, 2005, and 2008
• Supports unlimited SQL Server instances with an unlimited number of jobs.
• Allows to easily schedule SQL Server maintenance tasks: backups, index rebuilds, integrity checks, etc.
• Runs as Windows Service
• Email notifications on job success and failure
• And more...

Requirements:

• Windows 2000, 2003, XP, Vista, Windows 7
• .NET Framework 2.0
• SQL Server 2000, 2005, 2008

SQLScheduler is FREE!

v0.2.0.0 [Download] - March 15th, 2007

• Email notification can now include results of SELECT statements
• Command Timeout can now be specified for every job
• Many minor bug fixes and usability improvements
  

v0.1.0.0 - September 20th, 2006)

• Initial fully functional preview release.

Please Contact us if you have any questions or problems.

• SQLScheduler.exe – main GUI executable
• SQLSCheduler.WindowsService.exe – Windows service responsible for executing and scheduling jobs.
• SQLScheduler.Scheduler.dll – additional libraries
• SQLScheduler.exe.config – configuration file for the GUI executable
• SQLScheduler.WindowsSerivice.exe.config – configuration file for the Windows service.
• Jobs.config – configuration file storing details of every job
• Installservice.bat – batch file used to install the SQLScheduler service
• Uninstallservice.bat – batch file for uninstalling SQLScheduler service

Installation Steps:

1. Copy the contents of the archive to a directory on the target machine.
2. Run InstallService.bat file from the command prompt. The executing user account should have administrative rights on the machine.
   
3. Open SQLScheduler.WindowsService.exe.config file in Notepad and modify the Host name to point to the server name or ip address of your SMTP server. This server will be used to send notification emails. (The Windows service needs to be restarted for the changes to take effect.)

   <smtp deliveryMethod="Network" from="sqlscheduler@somedomain.com">

   <network host="mymailserver.com" userName="" password="" />

   smtp>

4. Run SQLScheduler.exe