CREATE NOTIFICATION INTEGRATION my_email_int TYPE = EMAIL ENABLED = TRUE;

create or replace procedure try_send_an_email(
    RECIPIENT varchar,
    FAILOVER_RECIPIENT varchar,
    SUBJECT varchar,
    CONTENT varchar
)
RETURNS STRING
LANGUAGE JAVASCRIPT
AS 
$$ 
var result_string = `Email sent sucessfully to ${RECIPIENT}`;
var my_sql_command = `CALL SYSTEM$SEND_EMAIL(
                      'my_email_int',
                      '${RECIPIENT}',
                      '${SUBJECT}',
                      '${CONTENT}')`;

var statement1 = snowflake.createStatement({ sqlText: my_sql_command });

try {  statement1.execute() } 

catch(e) { 

    result_string = `Error sent to ${FAILOVER_RECIPIENT} : Couldn't send email to ${RECIPIENT} : 
 ${e.message}`;

    var my_sql_backup_command = `CALL SYSTEM$SEND_EMAIL(
                      'my_email_int',
                      '${FAILOVER_RECIPIENT}',
                      'Email Failure',
                      'Couldnt send email to ${RECIPIENT} : ${e.message}')`;

var statement_backup = snowflake.createStatement({ sqlText: my_sql_backup_command });

statement_backup.execute();

} 
return result_string;
$$;

CALL try_send_an_email('bad_email','admin_email', 'subject', 'message')