How To Fix SMMSS_SQLJOBS079 - Entries per day must be > 0

SAP Error Message - Details

• Message type: E = Error

• Message class: SMMSS_SQLJOBS - Message class for SMSS_SQLJOBS

• Message number: 079

• Message text: Entries per day must be > 0

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_SQLJOBS079 - Entries per day must be > 0 ?

  The SAP error message SMMSS_SQLJOBS079 indicates that there is an issue with the configuration of the SQL jobs in the SAP system, specifically that the "Entries per day" parameter must be greater than zero. This error typically arises in the context of managing SQL jobs for the SAP system, particularly when using the SAP Solution Manager or similar tools.
  Cause:
  The error occurs when the system is configured to expect a certain number of entries (or jobs) to be processed per day, but the current configuration has this value set to zero or not defined. This can happen due to:
  
  Misconfiguration: The settings for the SQL jobs may not have been properly configured.
  System Updates: Changes in the system or updates may have reset or altered the configuration settings.
  Data Deletion: If data related to SQL jobs has been deleted or not properly maintained, it could lead to this error.
  
  Solution:
  To resolve the error, you can follow these steps:
  
  
  Check Configuration:
  
  Go to the relevant configuration settings for SQL jobs in your SAP system.
  Ensure that the "Entries per day" parameter is set to a value greater than zero.
  
  
  
  Adjust Parameters:
  
  If the parameter is set to zero, change it to a positive integer that reflects the expected number of SQL job entries per day.
  
  
  
  Review Job Scheduling:
  
  Ensure that the SQL jobs are scheduled correctly and that there are no issues preventing them from running.
  
  
  
  Consult Documentation:
  
  Refer to the SAP documentation or help resources for specific guidance on configuring SQL jobs and understanding the parameters involved.
  
  
  
  System Monitoring:
  
  Monitor the system for any other related errors or warnings that may indicate broader issues with job scheduling or execution.
  
  
  
  Contact SAP Support:
  
  If the issue persists after making the necessary adjustments, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  Transaction Codes: You may need to use transaction codes like SM37 (Job Monitoring) or SM36 (Job Scheduling) to check the status of jobs and their configurations.
  SAP Notes: Look for relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  System Logs: Check system logs for any additional error messages or warnings that could provide more context about the issue.
  
  By following these steps, you should be able to resolve the SMMSS_SQLJOBS079 error and ensure that your SQL job configurations are correctly set up.