Loading

How to pass parameter from sql to batch file

Saravana Kumar

10y1.2kSQL

How to pass parameter from sql to batch file  and how to send mail through .bat(batch) file.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Gareth Bradley10y ago
Accepted answer
What is the reason on wanting to use a Batch File?
If turned on you can use Database Mail and there is a nice proc within SQL Server itself called sp_send_dbmail, that way you dont need to worry about dropping data from sql.
https://msdn.microsoft.com/en-us/library/ms190307.aspx
Tejas Trivedi10y ago
Hi Saravana,

You can pass parameter using sqlcmd command. For sending an email from the bat file either you need to write powershell script or VBScript and then call it from the batch script.

Hope, this will give you high level idea to resolve your issue. Please feel free to write if more information is required.

Please don't forget to mark as answer if this helps.