MSSQL 2005 Express Edition Agent(Scheduler)

0
20

Microsoft’s Free Edition of its SQL Server Edition MSSQL 2005 Express Edition is not shipped with SqlServer Agent, This is the Major Drawback of SQL Server  and i made a lot of googling for the same

Finally i reached 

http://www.lazycoding.com/products.aspx

 

sqlschedulerstarted

 

 

 

Version history
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.

 

 

Installation

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 

 

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here