Mar 13 at 11:45 PM

HANA Cloud HDI - hdbschedulerjob - how to map all SCHEDULER JOB schedules to a workload class

394 Views Last edit Mar 13 at 11:46 PM 2 rev

Hi,

We are using HDI artifact hdbschedulerjob to create schedules for procedures in 1000+ HDI containers.

These statements are heavy on the DB resources, So, we are trying to map all these statements to a workload class but we are not able to identify the correct specific combination of parameters or session variables to map them.

We tried with APPLICATION_NAME which has the name of SCHEDULER JOB, also tried with APPLICATION_USER which has SCHEMA_NAME#OO; But these are different from schema to schema.

Can someone help us to identify the correct static parameters which are common for all the statements triggered by scheduler job? (Or a custom solution)

Note: workload class mapping supports only BEGINS with, = operator .. etc., It does not support LIKE.

Thanks,

Suchen.