Thursday, September 27, 2018

TIP: Listing background jobs by their frequency

Use report BTCAUX14 to view the following:

  1. Scheduling Frequency
  2. Number of times it's been run for the selected period
  3. How many instances are in released status
  4. How many are currently active 
  5. How many instances have been completed for the selected period
  6. How many were terminated
  7. Total Job Runtime
  8. Average Job Runtime
  9. Total Delay
  10. Average Delay

Wednesday, September 26, 2018

TIP: Changing background jobs in mass

We sometimes have a requirement to change several background jobs with the same change. E.g. You want to use a new user to execute a program or you have standardized the names of certain program and want to change the old program to the new program name. Well it is possible...
Report BTC_MASS_JOB_CHANGE can be executed to change jobs in mass.
This report allows you to change the following:

  • program / variant
  • user owner / step user
  • target server / group

There is a “Test Mode” option to test out the change prior to executing it for real

Tuesday, September 25, 2018

How do you determine your HANA Version

You can get to the HANA Version that you are using by following 1 of the following 3 techniques:
  1. SAP GUI: From the Menu select "System" --> "Status". Look for your Database System to get the Release info.
  2. SAP HANA Studio: Right click on system and select "Configuration and Monitoring" --> "Open Administration". Click on "Overview" tab and review "Version"
  3. OS Command Line: Open an OS terminal session and issue command "HDB version". Version will give you the needed detail.