September 10, 2008 at 7:14 pm
how to open sql server agent?
September 10, 2008 at 8:24 pm
Are you wanting to know how to turn the service on or are you wanting to know how to access Agent inside of SSMS?
September 10, 2008 at 10:40 pm
i want knowing how to turn on service of sql server agent
September 11, 2008 at 7:54 am
Start -> Programs -> SQL Server 2005 -> Configuration Tools -> Surface Area Configurations
When the windows opens, select the Surface Area Configuration for Services and Connections. When it opens, find the instance that you want to turn it on for. Expand the tree until you find sql server Agent. In the right window, select the option to "start" the service. If you want it to start automatically, then make sure you select that from the drop down box.
You can accomplish the same thing in SQL Server Confiuration Manager (which is in the same start menu as Surface Area Configurations)
When config manager opens, find the instance of sql server agent you want to start, right click on it, then select start. You can select properties and find the tab where you can set it up to start automatically.
Hope that helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply