Send email to admin periodically
I'm really out of my knowledge space on this one... I need to be able to email the results of a query to a specific email address every 24 hrs (say).
I can set up the queries, functions & triggers I need. I have set up a SendGrid account and even enabled custom SMTP provider settings... but I realise that's not what I want. I'm hoping that someone can outline the simplest process (baby steps please) for sending an email from a database trigger?
I can set up the queries, functions & triggers I need. I have set up a SendGrid account and even enabled custom SMTP provider settings... but I realise that's not what I want. I'm hoping that someone can outline the simplest process (baby steps please) for sending an email from a database trigger?
