Error saving job to database in SM36 Standard Job

In transaction code SM36, you are receiving error, “Error saving job to database” while scheduling standard job.

Error saving job xxxxxx to database
Message no. BT117

Diagnosis

The SAP system was unable to save the current job in the database. This failure suggests that there is a problem with the database system or with the network connections between the SAP application servers and the database system.

System Response

Job not saved and not scheduled.

Procedure

To analyze this problem, start by checking the system log for messages about network or database problems. You can also use the computing center management system to check your system for problems.

In transaction code SM21, you will notice some errors like below, this is what happened in our system. The variant DELSPOOL>30D is missing from report RSPO1041.

BP_CHECK_REPORT_VALUES: invalid report values detected. Reason:
BP_JOB_EDITOR: Job SAP_REORG_SPOOL is invalid. Reason:
> Variant DELSPOOL>30D (RSPO1041) is invalid

The report and variant check for background processing established that
a variant specified for a report is invalid.

The report and variant check for background processing determined
invalid values. An additional syslog entry specifies which values are
invalid.