MSSQL 2005 Express Edition Agent(Scheduler)

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 them you have any questions or problems.

 

 

The installation archive contains the following files:  

• 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