Sql Agent Xp's Disabled
Today, I changed the password for user account of SQL Server Agent, and then I restart the service.Ooops, Sql Server Agent service starts OK but it seems to be something wrong.
With these script I solved the problem.
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Agent XPs',1
go
reconfigure with override
go
sp_configure 'show advanced options',0
go
reconfigure with override
go
You can copy the lines before, or download the sql file