Start SQL Agent by T-SQL Command

[Andrea Moro]

As subject, I need to find a way to start sql agent by my own
sp.

Sorry, I didn't search on the net, but I'm releasing my app, and
monday it must run on the customer server.

 

[Richard Brown]

You can try issuing
xp_cmdshell 'net start sqlserveragent'

The returned recordset contains each line output by the startup process, you
can scan these to determine if errors occur, however, starting the agent a
second time throws an error message, but doesn't affect anything else.

The procedure also returns when the command is complete, so you should be
confident that agent is running when it comes back. You can specify the ",
nooutput" at the end of the line if you don't want the returned recordset,
but I would highly recommend it, just to check for errors.

Let us know if it helps.

 

[Herfried K. Wagner [MVP]]

Hello,

Sorry, I didn't search on the net, but I'm releasing my app, and
monday it must run on the customer server.

LOL.

 

[Andrea Moro]

Hello,



LOL.

What't the LOL issue?

 

[Herfried K. Wagner [MVP]]

Hello,

What't the LOL issue?

No, it's not a solution. Have a Google Search on what "LOL" means.

;-)

 

[Andrea Moro]

Hello,



No, it's not a solution. Have a Google Search on what "LOL" means.

;-)

I know what mean LOL, but I don't understand why y are laughing ..
or what let you to laugh

 

[Cor]

Andrea,

A lot of people are helping here beside there regulair job for free, but
maybe you did not know this?
And they expect to help people who are desperate and can not find things
after a long time searching.

Yes you are right it had to be COL, (Crying On Line).

Cor

 

[Herfried K. Wagner [MVP]]

Hello,

Yes you are right it had to be COL, (Crying On Line).

ROFL.

EOT.