How To Fix SQLM072 - Can't release update job. Check job release authorization and react. SQLM

SAP Error Message - Details

• Message type: E = Error

• Message class: SQLM - SQL Monitor messages to the world

• Message number: 072

• Message text: Can't release update job. Check job release authorization and react. SQLM

What causes this issue?

The SQLM periodic data refresh job could not be released. This is
probably due to insufficient user authorization for job releases.

System Response

Despite the missing update job, SQL Monitor can still be active and
collect data<(>,<)> but you won't be able to see and analyze this data
within transaction SQLM.

How to fix this error?

As a proper solution you should (re-)activate SQL Monitor with a user
that has the required release authorization (authorization Background
Processing: Operations on Background Jobs, RELE authorization, or object
Background Processing: Background Administrator).
As a workaround<(>,<)> you can try to update the SQLM data manually from
transaction SQLM, menu "SQL Monitor" -> "Refresh" -> "All Servers" /
"Local Server".

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SQLM072 - Can't release update job. Check job release authorization and react. SQLM ?

  The SAP error message SQLM072, which states "Can't release update job. Check job release authorization and react," typically occurs when there is an issue with the authorization required to release an update job in the SAP system. This error is often related to the background processing of update requests, which are essential for ensuring that changes made in the system are processed correctly.
  Cause:
  
  Authorization Issues: The user attempting to release the update job may not have the necessary authorizations. This can happen if the user lacks the required roles or permissions to execute or release update jobs.
  Job Status: The update job may be in a status that does not allow it to be released, such as being in a "waiting" or "error" state.
  System Configuration: There may be configuration settings in the SAP system that restrict the release of update jobs based on certain criteria.
  
  Solution:
  
  
  Check User Authorizations:
  
  Verify that the user has the necessary authorizations to release update jobs. This can be done by checking the user's roles and profiles in transaction SU01 (User Maintenance).
  Ensure that the user has the appropriate authorization objects, such as S_BTCH_ADM (for background job administration) and S_BTCH_JOB (for job management).
  
  
  
  Review Job Status:
  
  Use transaction SM37 (Job Monitoring) to check the status of the update job. Look for any errors or issues that may prevent the job from being released.
  If the job is in an error state, investigate the cause of the error and resolve it before attempting to release the job again.
  
  
  
  Check System Configuration:
  
  Review the system configuration related to update jobs. This may involve checking settings in transaction SM21 (System Log) or SCC4 (Client Administration) to ensure that there are no restrictions in place.
  
  
  
  Consult with Basis Team:
  
  If the issue persists, it may be necessary to consult with the SAP Basis team or system administrator. They can provide insights into system-level configurations and logs that may not be accessible to regular users.
  
  
  
  Re-attempt Job Release:
  
  After addressing any authorization issues or job status problems, attempt to release the update job again.
  
  
  
  Related Information:
  
  
  Transaction Codes:
  
  SM37: Job Monitoring
  SU01: User Maintenance
  SM21: System Log
  SCC4: Client Administration
  
  
  
  Authorization Objects:
  
  S_BTCH_ADM: Background job administration
  S_BTCH_JOB: Job management
  
  
  
  SAP Notes: Check for any relevant SAP Notes that may address specific issues related to update job releases or the SQLM072 error.
  
  
  By following these steps, you should be able to identify and resolve the issue causing the SQLM072 error in your SAP system.