hi Mudassar Ahmed Khan
i have requirement to send automated email to the registered user prior to one month of thier expiry date for that i am refering to your link
http://www.aspsnippets.com/articles/automated-email-notifications-using-sql-server-job-schedular.aspx
but, when i am exactly following step explained by you, i am getting this error ''Procedure or function sp_send_mail has too many arguments specified."
step i followed
1) create sample database
2)procedure from this link
http://www.aspsnippets.com/Articles/Send-SMTP-Email-using-SQL-Server.aspx
3)sql script [when i execute this script here i am getting error"Procedure or function sp_send_mail has too many arguments specified."" ]
Any suggetion please to resolve this issue
Thanks
John