February 19, 2014 at 11:47 am
Applied SP2 to SQL 2008 R2 stand alone machine. The Domain ID is sysadmin and is the ID that both the SQL Server service and agent accounts run under. When the job executes "The Execute permission was denied on the object 'sp_update_job'.... The job seems to complete fine with the exception of failing with the output having the permission error. No errors in the SQL Log or the SQL Agent log.
February 19, 2014 at 1:46 pm
I would check the errorlog immediately after the upgrade when the instance was in script upgrade mode and make sure there are no errors in there.
---------------------------------------------------------------------
February 19, 2014 at 1:48 pm
No errors in the SQL Server Log.
February 19, 2014 at 2:31 pm
FYI... I dropped and recreated the job. The errors have now stopped.
February 19, 2014 at 2:46 pm
interesting, thanks for posting back solution. was it just the one job with the error, others were OK?
---------------------------------------------------------------------
February 24, 2014 at 9:42 am
The others were working fine; which is why the error made no sense...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply