How To Fix SMMSS_SQLJOBS039 - Automatic log save turned off

SAP Error Message - Details

• Message type: E = Error

• Message class: SMMSS_SQLJOBS - Message class for SMSS_SQLJOBS

• Message number: 039

• Message text: Automatic log save turned off

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message SMMSS_SQLJOBS039 - Automatic log save turned off ?

  The SAP error message SMMSS_SQLJOBS039 indicates that the automatic log save feature for SQL jobs has been turned off. This can occur in the context of SAP systems that utilize SQL jobs for various background processing tasks.
  Cause:
  The primary cause of this error message is that the automatic log saving feature for SQL jobs has been disabled in the system configuration. This can happen due to:
  
  Configuration Changes: An administrator may have intentionally or unintentionally changed the settings related to SQL job logging.
  System Upgrades or Patches: Sometimes, after an upgrade or patch, certain settings may revert to defaults or change unexpectedly.
  Performance Considerations: In some cases, automatic log saving may be turned off to improve performance, especially if the logs are not needed for troubleshooting.
  
  Solution:
  To resolve the error and enable automatic log saving for SQL jobs, you can follow these steps:
  
  
  Check Configuration Settings:
  
  Navigate to the relevant configuration settings in your SAP system.
  Look for the settings related to SQL job logging, which may be found in transaction codes like SM37 (Job Monitoring) or SMM1 (SQL Job Management).
  
  
  
  Enable Automatic Log Saving:
  
  If you find that the automatic log saving is indeed turned off, enable it by adjusting the configuration settings.
  This may involve setting a parameter or checkbox that allows for automatic log saving.
  
  
  
  Review Documentation:
  
  Consult the SAP documentation or help files for your specific version of SAP to understand the implications of enabling or disabling this feature.
  
  
  
  Test the Changes:
  
  After making the changes, run a test SQL job to ensure that the logs are being saved automatically as expected.
  
  
  
  Monitor for Recurrence:
  
  Keep an eye on the system to ensure that the error does not recur. If it does, further investigation may be needed to determine if there are underlying issues or if the settings are being reverted.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes for any known issues or additional guidance related to this error message. SAP Notes often provide specific instructions or patches that can help resolve issues.
  System Logs: Review system logs for any additional error messages or warnings that may provide context for why the automatic log saving was turned off.
  User Permissions: Ensure that the user making the changes has the necessary permissions to modify system settings.
  
  If the issue persists after following these steps, consider reaching out to SAP support for further assistance.