Tuesday, January 8, 2013

SQL Agent Jobs are not running even they are enabled

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
delete from syssubsystems
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: