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...
> 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
>--Original Message--
>Hi,
>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...
>> 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
>
>.
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment