Starting SQL Server Agent

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

wz700 SSCertifiable Points: 7133 More actions · Answer 1

SSCertifiable

Points: 7133

April 13, 2005 at 8:31 pm

xp_cmdshell 'net stop sqlserveragent'

otis-224947 Valued Member Points: 61 More actions · Answer 2

Valued Member

Points: 61

April 13, 2005 at 8:39 pm

It's that simple?

Thanks @wz700

andyobl Right there with Babe Points: 767 More actions · Answer 3

OR

EXEC sp_configure 'scan for startup procs', '1'

go

xp_servicecontrol 'stop', 'sqlserveragent'

go

xp_servicecontrol 'start', 'sqlserveragent'

go

EXEC sp_configure 'scan for startup procs', '0'

go