This topic describes how to use a DingTalk chatbot to send a notification after an asynchronous SQL statement is executed in the Data Lake Analytics (DLA) console.
If you want to use a DingTalk chatbot to send a notification after an asynchronous SQL statement is executed in the DLA console, you must contact the DLA technical team in advance to help you create and configure a DingTalk chatbot.
Syntax
-
Send a notification after an asynchronous SQL statement is executed in the DLA console:
/*+ run_async=true, mq-notify-by=dingtalk*/ select * from xxxx .... ;
-
To prevent excessive notifications, specify the minimum running duration for an asynchronous SQL statement:
/*+ run_async=true, mq-notify-by=dingtalk, mq-threshold-secs=100 */ select * from xxxx .... ;
If the running duration exceeds 100 seconds (the value of the
mq-threshold-secs
parameter is greater than or equal to 100), the DingTalk chatbot sends a notification. Otherwise, no notifications are sent.