SQL Server Agent - Agent XPs Disabled
page 1 of 3
Published: 21 Sep 2009
Unedited - Community Contributed
Abstract
Agent XPs option is used to enable the SQL Server Agent extended stored procedures on the server. When this option is disabled, the SQL Server Agent node is not available in SQL Server Management Studio Object Explorer.
by Aamod Thakur
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 1977/ 159

Introduction

Today, Disk space on one of my company's server was Full. As a Massive database was growing more massively, we were moving some databases to another drive. At one point the SQL Server got stuck.After rebooting the server, noticed that SQL Server Agent was disabled.  Message shown in the Object Explorer was SQL Server Agent (Agent XPs disabled). Well, I had seen this message a few times on other Servers before this but had ignored it as there werent any important Maintainence Plans or Jobs Scheduled. But this time that Server was loaded with important Jobs and Maintainence plans hence had to find out a Solution this time .


View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 1 and 2 and type the answer here:

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2009 ASPAlliance.com  |  Page Processed at 11/22/2009 4:21:11 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search