How To Fix SMMSS_SQLJOBS004 - Not running on MSSQL!

SAP Error Message - Details

• Message type: E = Error

• Message class: SMMSS_SQLJOBS - Message class for SMSS_SQLJOBS

• Message number: 004

• Message text: Not running on MSSQL!

What causes this issue?

System databse platform is not SQL Server.

System Response

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

How to fix this error?

The report or function is not possible to execute in non-mssql server
system.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SMMSS_SQLJOBS004 - Not running on MSSQL! ?

  The SAP error message SMMSS_SQLJOBS004 typically indicates that a scheduled SQL job is not running on Microsoft SQL Server (MSSQL). This error can arise due to various reasons, and understanding the cause is essential for troubleshooting and resolving the issue.
  Possible Causes:
  
  SQL Server Agent Not Running: The SQL Server Agent, which is responsible for executing scheduled jobs, may not be running.
  Job Disabled: The specific job may be disabled in SQL Server.
  Permissions Issues: The user account under which the job is running may not have the necessary permissions to execute the job.
  Job Schedule Issues: The job may not be scheduled correctly or may have been missed due to a configuration issue.
  Database Connectivity Issues: There may be connectivity issues between SAP and the SQL Server database.
  Resource Constraints: The SQL Server may be under heavy load or experiencing resource constraints, preventing the job from executing.
  
  Solutions:
  
  
  Check SQL Server Agent:
  
  Ensure that the SQL Server Agent service is running. You can check this in SQL Server Management Studio (SSMS) under the "SQL Server Agent" node.
  
  
  
  Verify Job Status:
  
  In SSMS, navigate to SQL Server Agent > Jobs, and check the status of the job in question. Ensure it is enabled and not disabled.
  
  
  
  Review Job Permissions:
  
  Ensure that the account running the job has the necessary permissions to execute the job and access the required resources.
  
  
  
  Check Job Schedule:
  
  Review the job's schedule to ensure it is set up correctly. Make sure the job is scheduled to run at the expected times.
  
  
  
  Examine Logs:
  
  Check the SQL Server Agent job history and logs for any error messages or warnings that could provide more context on why the job is not running.
  
  
  
  Test Connectivity:
  
  Ensure that SAP can connect to the SQL Server database without issues. You can test this by running a simple query from SAP to the database.
  
  
  
  Monitor Resource Usage:
  
  Check the SQL Server performance metrics to see if there are any resource constraints (CPU, memory, disk I/O) that could be affecting job execution.
  
  
  
  Restart SQL Server Agent:
  
  If all else fails, consider restarting the SQL Server Agent service to see if that resolves the issue.
  
  
  
  Related Information:
  
  Documentation: Refer to SAP and Microsoft SQL Server documentation for more detailed troubleshooting steps and best practices.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Community Forums: Engage with SAP community forums or Microsoft SQL Server forums for additional insights and shared experiences from other users.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.