send sms as a notification when tablespace full is
Hi,
how could I achieve that, to send SMS when a tablespace full is!
we have the following threshold:
begin
DBMS_SERVER_ALERT.set_threshold(metrics_id => DBMS_SERVER_ALERT.tablespace_pct_full,
warning_operator => DBMS_SERVER_ALERT.operator_ge,
warning_value => '90',
critical_operator => DBMS_SERVER_ALERT.OPERATOR_GE,
critical_value => '97',
observation_period => 1,
consecutive_occurrences => 1,
instance_name => NULL,
object_type => DBMS_SERVER_ALERT.object_type_tablespace,
object_name => NULL);
end;
and we already have an OS Script which able to send SMS and Emails.
how can I do that in SQL ?
how can I do that in EM ?