SQLandSai
Labels
Differences
(38)
MongoDB
(13)
MySQL
(10)
Oracle
(6)
ORACLE DBA
(1)
Performance Tuning
(13)
PTuning
(3)
Scenarios
(4)
Scripts
(35)
SQLDBA
(99)
SQLDeveloper
(66)
SSIS
(5)
SSRS
(8)
Troubleshooting
(37)
Sunday, 1 May 2016
SQL DBA : My SQL Server Agent is not started after MSDB rebuild so how you will fix this issue ?
Execute the below script to fix this issue permanently .
sp_configure 'show advanced options', 1;
RECONFIGURE;
sp_configure 'Agent XPs', 0;
RECONFIGURE;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment