|
Answer» Hi
I am new to batch files.
I want to write a batch file which will take parameter like $NODE (Which NEED to worry it will be fetched automatically )
It should OPEN a sql connection and use a select command to query in a particular table and give me e-mail id against that node (e-mail is onother column which is mapped to node NAMES)
so this e-mail id I will used to send some escalation using sendmail or blat utility.
I hope some ONE might have done this using batch file.
this is my forst question on this forum.
If any info is needed let me know.. I am also writing.. will post once completed..
thanks
RGDS
COOL_KK This is generally DATABASE specific but for SQL Server check out the OSQL or SQLCMD programs. They both offer command line help (/?) which may prove useful.
Solutions like this are really easier with many of the Windows Scripting languages which could also handle the mailing duties.
Good luck.
|
