SQL Server Agent Jobs are not invoked automatically even though they are scheduled and enabled.
Below steps resolved my issue, i am not recommend to execute the below commands but it works for me.
use msdb
select * from syssubsystems
go
delete from syssubsystems
go
select * from syssubsystems -- Make sure everything is deleted
exec msdb.dbo.sp_verify_subsystems 1 -- Everything will be re-created into syssubsystems table.
Restart the SQL Server Agent
No comments: