Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Friday, July 3, 2015 12:46 AM
My SQL server agent had stopped. So I started it. After I started it, the activity monitor showed that "Agent XPs are disabled". Then I ran
EXEC SP_CONFIGURE 'Agent XPs',1
GO
RECONFIGURE
After that my activity monitor shows the jobs again. But the next run is shown as "Not Scheduled" and when I give "start job at step" it gives an error. What do I do? Please help.
mayooran99
Friday, July 3, 2015 5:06 AM ✅Answered | 1 vote
You might need a complete server restart. That should fix the problem.
I have seen this issue in the past.
Friday, July 3, 2015 2:53 PM ✅Answered
Complete server restart in the sense I have to restart all services in SQL Server configuration manager one by one again?
mayooran99
This can sometimes be caused if there has been a change to the Service Account, e.g. you have changed the password or introduced a new Service Account.
Rebooting the Server itself will usually fix this issue (as Kumar has already suggested).
Please click "Mark As Answer" if my post helped. Tony C.
Friday, July 3, 2015 12:54 AM
What is the error you got? Did you check the properties of SQL Server Agent and see if the "Auto restart SQL Server Agent if it stops unexpectedly" is checked?
A Fan of SSIS, SSRS and SSAS
Friday, July 3, 2015 1:00 AM
It said SQL Server agent is not running, but it was running. And yes auto restart is on. Somehow it was on a stopped state and from that moment on wards jobs are not running. I tried restarting. Still the same situation.
mayooran99
Friday, July 3, 2015 1:11 AM
What is the run_value from
EXEC SP_CONFIGURE 'Agent XPs'
A Fan of SSIS, SSRS and SSAS
Friday, July 3, 2015 2:00 AM
It is 1. I can see all the jobs in the activity monitor as well.
mayooran99
Friday, July 3, 2015 3:57 AM
It is 1. I can see all the jobs in the activity monitor as well.
mayooran99
Ok you mean to say SQL Server agent is running but jobs are not running correct.
Go to SQL Server configuration manager or you can go to SSMS and refresh whole thing, what is statu of SQL Server agent now
Its highly unlikely that SQL agent is running but job is not. Did you manually tried to run the job
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
Friday, July 3, 2015 6:58 AM
Check for error messages in the "SQLAGENT.OUT" file.
Tibor Karaszi, SQL Server MVP | web | blog
Friday, July 3, 2015 2:27 PM
Yes I went to configuration manager and there it states its running. If it was not running I wouldn't have been able to access the activity monitor anyway. And I get the error saying "SQL Agent is not running" when I try to run the job manually rather than on a schedule.
mayooran99
Friday, July 3, 2015 2:28 PM
Complete server restart in the sense I have to restart all services in SQL Server configuration manager one by one again?
mayooran99
Friday, July 3, 2015 2:38 PM
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
gowill help you...
Vote As Helpful if it helps to solve your issue
Friday, July 3, 2015 2:46 PM
Make sure that the SQL Server Agent service is set to start automatically.
A Fan of SSIS, SSRS and SSAS