script to clear the queue entries for AutoEmail if Designer Plus is also configured

Version 2
    Question

    script to clear the queue entries for AutoEmail if Designer Plus is also configured

    Answer

     

    DELETE FROM QUEBUFFE_HDW
    WHERE (NOTEKEY_HDW IN
                              (SELECT BUFFER_HDW
                                FROM QUEUE_HDW
                                WHERE APPID_HDW = 'AUTOEMAIL')) ;

     

     

    DELETE

    FROM queue_hdw

    WHERE appid_hdw = 'AUTOEMAIL' ;

     

    Note: You must apply the scripts in the order shown - quebuffe_hdw first then queue_hdw.

    Environment

    Classic.  All versions