Hi All,

Think we're hitting a dead end now, stuck here.

Hope somebody else can help out?

Thanks.

- Peter

Hi MyDoggieJessie,

Thanks for your reply.

I've tried that and there is no result displayed.

Please help.

- Peter

Hi MyDoggieJessie,

Thanks for your reply.

Which section in the script shoud I insert that SELECT query?

- Peter

Hi All,

Think we're really stuck here as I don't see anymore replies.

Hope somebody else can help out?

Thanks.

- Peter

Hi MyDoggieJessie,

Thank you for your reply and help.

I've inserted the SELECT command, but nothing come out. No errors. No result displayed. No email received.

All I can see is this message:

Command(s)...

Hi MyDoggieJessie,

Thank you for your reply and help.

I'm still learning SQL queries.

Could rovide the required SQL query to check for these variables?

@database_name

@server

@SubjectHTML

@tablecopyHTML

@tablerestoreHTML

And where should it be inserted?

- Peter

Hi Satnam,

Thanks for your reply.

As I've posted earlier, there are no errors from your script, email is sent out but the email content is empty. That's the current status.

Appreciate for...

Hi MyDoggieJessie,

Thank you for your reply.

As I've posted earlier, there are no errors from Satnam's script, email is sent out but the email content is empty. That's the current status.

Appreciate...

Hi MyDoggieJessie,

Thank you for your reply.

I'm not too sure which error are you referring to?

Issue from your script or Satnam's one?

Please clarify.

- Peter

Hi Satnam,

Would like to know if you're able to spot the issue yet?

Thanks.

- Peter

Hi Satnam,

Thanks for your reply.

I'm currently using the same script that you've posted earlier, perhaps you can review it from there?

Thanks.

- Peter

Hi Satnam,

Thanks for your reply.

I've followed your method and did the testing. The test email was sent out succesfully and received in my inbox. I knew the database mail had...

Hi Satnam,

Thanks for your reply.

Yes, I've noticed that threshold. I've tried to change it from 15 minutes to 1 minutes which I've applied for threshold of backup, copy and restore,...

Hi Satnam,

Thanks for your reply.

I've tried your method and there is no errors now.

However, there is no email being sent out. I've refreshed my mail multiple times and still no...

Hi Satnam,

Thanks for your reply and kindness to post the entire script.

I've recalled what I've tried previously when I'm doing the testing now.

There are some errors with the syntax and...