cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

hana backup schedule

kalyan
Participant
0 Likes
945

If we are scheduling backups via hana cockpit for a HANA DB, the schedule gets stored somewhere in HANA DB. Does anyone know which table or monitoring view this schedule information gets stored in. I checked m_backup* views but cannot find it anywhere. Any help is appreciated.

Accepted Solutions (0)

Answers (3)

Answers (3)

RaymondGiuseppi
Active Contributor
0 Likes

Did you already check in your system for tables such as 

  • _SYS_XS.JOB_SCHEDULES 
  • _SYS_XS.JOBS
  • _SYS_XS.JOB_LOG

Look for Authorizations Needed for Monitoring and Administration In SAP HANA Cockpit 

Marco_2
Newcomer
0 Likes

Hello

You can see view M_SCHEDULER_JOBS

select * from M_SCHEDULER_JOBS where STATUS='SCHEDULED';

The job parameters:
select * from SCHEDULER_JOB_PARAMETERS;

and the called procedures

select * from SCHEDULER_JOBS;

Regards

Marco

mamartins
Active Contributor
0 Likes

SAP doesn't provide much information about this, this is what I could find: Monitoring Views for the Backup Catalog

The catalog is stored on the file system, not on the DB.