Sunday, February 12, 2012

can not start sql agent

SQL Book Online lists command sqlagent.exe can start SQL
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
quote:

> SQL Book Online lists command sqlagent.exe can start SQL
> agent.
> I tried to start sql agent by using sqlagent.exe from
> command prompt. But get error:
> "You must start SQLServerAgent as a service (using the SQL
> Server Service Manager)"
> Does Book Online give wrong option?
> Thanks for suggestions.
> -Tom
>
|||Hari,
Thanks so much. It works!
-Tom
quote:

>--Original Message--
>Hi,
>You can use either Control panel -- Administrative

tools -- Services --
quote:

>there you can select and start "SQL Agent" service.
>Otherwise from command prompt you can issue below command

to start the sql
quote:

>agent service.
>net start sqlagent
>Note:
>The above service name will be SQLagent$instance_name if

your sql server is
quote:

>a named instance.
>Thanks
>Hari
>MCDBA
>
>"Tom Torain" <TST_MC@.hotmail.com> wrote in message
>news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
SQL[QUOTE]
>
>.
>

No comments:

Post a Comment