Thanks all!! 🙂

Finally, I am able to send a Test Mail from "Database Mail".

But, when i configure an operator and include it in a Job, it throws me an error...

I have added an exception in Firewall.

Is there any way to check whether the SMTP server allow me to send mail via it?

I have added DatabaseMail90.exe as an exception in my Antivirus Program.

I am also able to send mail through outlook.

Am i missing anything else?

I cannot set the interval because for one parameter selection the data is between 0 to 2 and for the other it is between 0 to 1000.

Is there any other...

Thanks a lot Simon!!

Your code worked perfectly!! 🙂

Hi Simon,

Thanks for ur input.

But, the no. and name of columns BU1, BU2 etc... and the rows Skill1, Skill2 etc... is also fixed.

I cannot hardcode any values.Hence I cannot...