abhilash,abhilash nair,abhilash s,kothamangalam,inchoor,malayalam,linux,kerala,kochi,cochin,ernakulam,india,redhat,ubuntu,mssql server,asp,asp.net,web hosting,web development,wordpress,joomla,cpanel,plesk

MSSQL 2005 Express Edition Agent(Scheduler)

Posted in: MSSQL Server

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

Â

Â

Â

Â

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:

Copy the contents of the archive to a directory on the target machine.
Run InstallService.bat file from the command prompt. The executing user account should have administrative rights on the machine.Â
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>
Run SQLScheduler.exeÂ

Â

Â

No Comments

Start the ball rolling by posting a comment on this article!

Leave a Reply

Subscribe To meabi.com Articles

Mobile Web Browsing
meabi.com is available from mobile web browsers with a clean mobile friendly interface, Just point your mobile webbrowser to the blog URL ie.http://meabi.com
thatz all . see u there thanks.

Enter your email address:

Delivered by FeedBurner | Subscribe Now
The Author

The Author, S.Abhilash is a Technology Enthusiast., and is having past one decades experience in IT related technologies including RDBMS, Application tools,IDEs , Web development Platforms, Server side Scripting , GUI , Server monitoring etc..
This time he is concentrating on IIS/Apache Server side Scripting , RDBMS, along with Server platforms as MS Windows and Redhat.
and is maintaining this from his own experience channel.

Read More | Contact
Featured Stories
- my n73, more than a phone
  10 September 2010 5:25 PM | No Comments
  In the early 2008 i replaced my motorola razer with the fantastic nokia n73 the leading multimedia cum smartphone of that time It was shipped with a beautiful case with charger,headset,datacable and a series of leaflets and operation manual operating system s symbian s60 ,...
  Read More
- creating a mobile friendly website, things to consider
  10 September 2010 1:42 PM | No Comments
  mobile browsing is getting good market day by day.almost all leading websites have its own mobile friendly version to view correctly on all leading mobile devices mobile browsing has its owm primitives and limitations , the key difference is the screen size its around 1/6...
  Read More
- Blog from your Nokia Mobile phone
  10 September 2010 10:28 AM | No Comments
  likely this was everyones question who hve a blog and a nokia smart phone with internet how to blog from my mobile ? Almost every one should think of it atleast for once i am sure.,and finally Here is the solution after a lot...
  Read More
- Snaptu, the mobile Social Media Client for Java
  24 August 2010 8:54 AM | 2 Comments
  Snaptu, the best social media client for Java based smartphones, URL :http://snaptu.com very pleaseing application and a builtin tool collection of almost all leading Social Networking platforms Key Features, Facebook and Twitter n same basket Mashable , Reuters,Picasa, Flickr, BBC and more … Ultra FAST...
  Read More
- Hyper link to Dial a Phone Number From Mobile Browser
  22 August 2010 7:44 AM | No Comments
  Nowadays Web browsing is not a single practise from traditional webbrowsers from pc/laptops, this is the time of mobility and most of the web surfers depends on mobile devices to search the web., even social medias play more on mobiles, smart phones/ palm tops like...
  Read More
- Dsable / Enable All Triggers in a table from SQL Server
  04 August 2010 2:53 PM | No Comments
  to Enable ALTER TABLE <tablename> ENABLE TRIGGER ALLto Disable ALTER TABLE <tablename> DISABLE TRIGGER ALL
  Read More
- Tweet from Google Chrome
  03 August 2010 6:21 PM | No Comments
  No need to go twitter.com tweet in b/w when u work install metrist twitter client extension for google chrome and tweet with a single click here is the screen shot down load it from https://chrome.google.com/extensions/detail/aefaeloiencfjnaljicdoieoekoecmha
  Read More

About Arras Theme

Copyright meabi.com. All Rights Reserved.