Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

SQL Server 2008 (R2) SQL Agent

From Wiki

Jump to: navigation, search

As we know, SQL Server Express does not have the SQL Server Agent available as a feature. For years we've had to use windows scheduled tasks and other means of calling scripts to handle maintenance.

With SQL Server 2008 and R2, you might notice that there is now a SQL Server Agent Service listed in the SQL Server Configuration manager. Don't get excited! This service is disabled and even on trying, you cannot enable it. The service I believe is for upgrade paths and will not function until you do just that. Upgrade!

False happy news! Maybe next release we'll get it (or a stripped version)

--onpnt 18:33, 7 July 2010 (GMT)

784 Rating: 2.5/5 (31 votes cast)