How to enable SQL Server Agent
Procedure:
Execute the following Queries and refresh the server
Step1:
exec sp_configure 'agent XPs'
if it display an error that advanced options are disabled then by running the following query enable the show advanced options and reconfigure
Step2: Run the Query to enable advanced options
exec sp_configure 'show advanced options' , 1
go
reconfigure
go
step 3:
exec sp_configure 'show advanced options'
go
Step4:
Enable agent XPs by using the query
exec sp_configure 'agent XPs'
go
exec sp_configure 'agent XPs',1
go
reconfigure
go
exec sp_configure 'agent XPs'
Step5:
now restart the SQL Server Agent / Server. so that SQL Server Services should be enabled
still if it doesn't start then
Step 6:
goto start-->run type services.msc and press OK
Step 7:
Services window will be opened then goto SQL Server Agent, Right click on it and go for start
Now we can see the SQL Server Agent started in our Object Explorer
Procedure:
Execute the following Queries and refresh the server
Step1:
exec sp_configure 'agent XPs'
if it display an error that advanced options are disabled then by running the following query enable the show advanced options and reconfigure
Step2: Run the Query to enable advanced options
exec sp_configure 'show advanced options' , 1
go
reconfigure
go
step 3:
exec sp_configure 'show advanced options'
go
Step4:
Enable agent XPs by using the query
exec sp_configure 'agent XPs'
go
exec sp_configure 'agent XPs',1
go
reconfigure
go
exec sp_configure 'agent XPs'
Step5:
now restart the SQL Server Agent / Server. so that SQL Server Services should be enabled
still if it doesn't start then
Step 6:
goto start-->run type services.msc and press OK
Step 7:
Services window will be opened then goto SQL Server Agent, Right click on it and go for start
Now we can see the SQL Server Agent started in our Object Explorer
No comments:
Post a Comment