Hi, it is possible with a query. All local monitoring tasks are sharing the same type (tasktypeid=34).
So, a way to bulk configure all of them is:
insert into task_pset_props
select taskpsetid, 'fs.alert.threashold', '85' from task_pset where taskid in (select taskid from task where tasktypeid=34)
and taskpsetid not in (select taskpsetid from task_pset_props where name = 'fs.alert.threashold')
this query is adding the correct property to configure alert at 85%.
After that, tasks have to be notified about the change. This can be done with following query:
insert into task_exec_req (taskexecreqid, taskid, ts, reqtype, status)
select sqn_nextval('task_exec_req'), taskid, get_sysdate(), 'SENDCONF', 'TODO' from task where tasktypeid=34
this query is requesting to scheduler supervisor to update configuration for such tasks.
Thanks Marco. This worked as expected, after changing the value and the second query made it to enable it for the tasks.
For other users, just small tips for the same query:
Do commit; after each query, And in the second query which enables the settings for the tasks, this is the correct one:
insert into task_exec_req (taskexecreqid, taskid, ts, reqtype, status, exects, taskpsetid)
select TASK_EXEC_REQ_SQN.NEXTVAL, taskid, get_sysdate(), 'SENDCONF', 'TODO', get_sysdate(), taskpsetid from task_pset where taskid in (select taskid from task where tasktypeid = 34); commit;