I notified so many times by the Object Explorer when I go to check the SQL Server Agent jobs. The notification is “ Agent XPs disabled ”. Then I need to run the following queries to enable SQL Server Agent XPs, EXEC SP_CONFIGURE 'show advanced options',1 GO RECONFIGURE GO EXEC SP_CONFIGURE 'Agent XPs',1 GO RECONFIGURE GO EXEC SP_CONFIGURE 'show advanced options',0 GO RECONFIGURE GO After running above script it will be enabled, I think you were getting this notification many times. So please share me your experience as “Why this SQL Agent XPs disabled sometime automatically after enabling it?”.
Towards the innovative SQL ideas