Hello.
I have a query which joins tables from 2 databases. If this query returns any records I'd like to send an email notification.
I first thought of using a DTS package but it only seems to be possible to execute a task against one connection and therefore one database at a time.
I also thought of scheduling a bit of vbscript to check this and send the email but can't see a way of doing this against more than one database.
Does anyone have any ideas please?
Thanks.
I have a query which joins tables from 2 databases. If this query returns any records I'd like to send an email notification.
I first thought of using a DTS package but it only seems to be possible to execute a task against one connection and therefore one database at a time.
I also thought of scheduling a bit of vbscript to check this and send the email but can't see a way of doing this against more than one database.
Does anyone have any ideas please?
Thanks.