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.