How To Fix SMMSS_SQLJOBS109 - DB13 job cleanup call is cancelled by user

SAP Error Message - Details

• Message type: E = Error

• Message class: SMMSS_SQLJOBS - Message class for SMSS_SQLJOBS

• Message number: 109

• Message text: DB13 job cleanup call is cancelled by user

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_SQLJOBS109 - DB13 job cleanup call is cancelled by user ?

  The SAP error message SMMSS_SQLJOBS109 indicates that a job cleanup process in the DB13 transaction (which is used for managing database backups and other database-related jobs) has been canceled by the user. This can happen for various reasons, and understanding the cause and potential solutions can help you address the issue effectively.
  Cause
  
  User Intervention: The most straightforward cause is that a user manually canceled the job cleanup process while it was running.
  Timeouts: If the job takes too long to complete, it may be canceled due to a timeout setting or user action.
  System Performance: If the system is under heavy load, users might cancel jobs that are taking longer than expected.
  Misconfiguration: There could be configuration issues in the job scheduling or database settings that lead to unexpected behavior.
  
  Solution
  
  Check Job Status: Go to transaction DB13 and check the status of the job. If it was canceled, you may need to restart the job cleanup process.
  Review Logs: Look at the job logs for any additional error messages or warnings that could provide more context about why the job was canceled.
  User Communication: If the job was canceled by a user, communicate with the team to understand why it was canceled and if it needs to be restarted.
  Adjust Timeout Settings: If timeouts are an issue, consider adjusting the timeout settings for job execution to allow more time for completion.
  System Performance Monitoring: Monitor system performance to ensure that it can handle the load during job execution. If necessary, schedule jobs during off-peak hours.
  Configuration Review: Review the configuration settings for job scheduling and database management to ensure they are set up correctly.
  
  Related Information
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as DB13 (Database Backup and Restore) and SM37 (Job Monitoring) to manage and monitor jobs effectively.
  SAP Notes: Check SAP Notes for any known issues or patches related to job scheduling and cleanup processes.
  Documentation: Refer to SAP documentation for best practices on job scheduling and database management to avoid similar issues in the future.
  
  By following these steps, you should be able to address the SMMSS_SQLJOBS109 error and ensure that your database job cleanup processes run smoothly.