Symptom
- SUM fails in phase MAIN_SWITCH/SQLDB_MSS_MSSPROCSTHROW.
SQLSTMTSTD.OUT shows:
1EETQ008 Error message: DBSL error 99 (db code 50000):
1EETQ009X Creation of stored procedure 'sap_zz_create_jobs' threw SQL Error 229:
1EETQ009X The EXECUTE permission was denied on the object
1EETQ009X 'sp_update_jobschedule', database 'msdb', schema 'dbo'.
1EETQ003 exit code: "20" - Run SE38 report MSSPROCS and then "Execute all" and then "Execute SQL Scripts" fails with the same error:
Msg 229, Level 14, State 5, Procedure sp_update_jobschedule, Line 1The EXECUTE permission was denied on the object 'sp_update_jobschedule', database 'msdb', schema 'dbo'.
Read more...
Environment
- SAP systems based on Microsoft SQL Server
Keywords
EXECUTE permission, denied, sap_zz_create_jobs, sp_update_jobschedule, SQL Error 229 , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.