On the Journey to be a SQL Server Professional
SQL Server Administration, Development and B.I. Development related
Error in Executing a SQL Server Agent Job
Problem:
Executed as NT AUTHORITY\SYSTEM. Got an error:
Invalid object name 'sysjobs'. [SQLSTATE 42S02] (Error 208).
Solution:
Just need to fully qualify it as msdb.dbo.sysjobs
Newer Post
Older Post
Home