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.
SAP Knowledge Base Article - Preview