Do you have any question about this error?
Stop googling SAP errors. Use our Free Essentials plan instead - no credit card needed. Start Now →
Message type: E = Error
Message class: SMMSS_SQLJOBS - Message class for SMSS_SQLJOBS
Message number: 039
Message text: Automatic log save turned off
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.
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.
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) orSMM1
(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:
If the issue persists after following these steps, consider reaching out to SAP support for further assistance.
Get instant SAP help. Sign up for our Free Essentials Plan.
SMMSS_SQLJOBS038
Action pattern successfully applied
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SMMSS_SQLJOBS037
Applying action pattern cancelled
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SMMSS_SQLJOBS040
Internal error: problem during delete
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
SMMSS_SQLJOBS041
Internal error: problem during insert
Self-Explanatory Message Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of...
Click on this link to search all SAP messages.