Enabling Agent XPs

If you are having problems with the SQL Server Agent you might want to check if Agent Xps are enabled.

Run the following:

sp_configure ‘show advanced options’, ‘1’

Then

RECONFIGURE

This will reconfigure sp_configure to give you a little more detail for the options you want to change
So run: sp_configure

Check the config_value of the Agent Xps, if it is not 1 simply run:

sp_configure ‘Agent Xps’, ‘1’

Then

RECONFIGURE

Cheers

Leave a Reply

Your email address will not be published. Required fields are marked *