Oracle job scheduler

To view the current schedules:

• select * dba_scheduler_schedules;
  
  

Also:

• select * from dba_scheduler_jobs;

To view job run histories:

• select * from dba_scheduler_job_log;

See also SAP note 974781

Make the cancel print button active

By default the Cancel button in the print dialog is greyed out:

• Run regedit
• Go to: HKEY_CURRENT_USER\Software\SAP\SAPlpd\SAPLPD
• Add character string "EnableCancelButton"
• Enter value '1'

Change takes effect immediately

See SAP note 1449136

Creating and viewing memory snapshots in SAP

• Run transaction S_MEMORY_INSPECTOR

• To create a memory snapshot, enter /hmusa into the transaction field
• Message shown in status bar:

Compare SAP config between two systems

• Run transaction SCU0

Choose SAP Refernce IMG
Click Create

Choose Select activites
Click the green tick

Choose an area and click the green tick

Enter a description and choose and R/3 (RFC) connection

Click either Total comparison or Total comparison in background

Note: This process uses a lot of session memory, particularly from the extended memory area whether run in foregoround or background.

Running SQL statements in SAP (Oracle and DB2)

Oracle

Free-form statements:

• SE38
• Program name RSORADJV
• Execute

Using drop down menu options:

• SE38
• Program name RSORAVDV
• Execute

DB2

• Run transaction ST04
• Expand Diagnostics
• Double-click SQL Command Line