• how about creating a trigger on 'myTable' for inserts, and creating a separate 'audit' table

    When a new row is inserted into 'myTable', insert a row into the audit table with the date/time of the insert and any other values needed -

    then set up the scheduled job to run every 30mins and check the dates in the audit table, sending an email if one or more of the rows was inserted in the previous 30mins