April 18, 2017 at 7:56 pm
trying to run below netstat via SQL agent job every 10 sec and save output to txt file and it fails.
Please help me how to achieve below netstat to collect info every 10 secs.
netstat -an|find /C "EST"
netstat -an | find “TIME”
netstat -an|find “CLOSE”
Error message:
Displays protocol statistics and current TCP/IP network connections. NETSTAT [-a] [-b] [-e] [-f] [-n] [-o] [-p proto] [-r] [-s] [-x] [-t] [interval] -a Displays all connections and listening ports. -b Displays the executable involved in creating each connection or listening port. In some cases well-known executables host multiple independent components, and in these cases the sequence of components involved in creating the connection or listening port is displayed. In this case the executable name is in [] at the bottom, on top is the component it called, and so forth until TCP/IP was reached. Note that this option can be time-consuming and will fail unless you have sufficient permissions. -e Displays Ethernet statistics. This may be combined with the -s option. -f Displays Fully Qualified Domain Names (FQDN) for foreign addresses. -n Displays addresses and port numbers in numerical form. -o Displays the owning process ID associated with each connection. -p proto Shows connections for the protocol specified by proto; proto may be any of: TCP, UDP, TCPv6, or UDPv6. If used with the -s option to display per-protocol statistics, proto may be any of: IP, IPv6, ICMP, ICMPv6, TCP, TCPv6, UDP, or UDPv6. -q Displays all connections, listening ports, and bound nonlistening TCP ports. Bound nonlistening ports may or may not be associated with an active connection. -r Displays the routing table. -s Displays per-protocol statistics. By default, statistics are shown for IP, IPv6, ICMP, ICMPv6, TCP, TCPv6, UDP, and UDPv6; the -p option may be used to specify a subset of the default. -t Displays the current connection offload state. -x Displays NetworkDirect connections, listeners, and shared endpoints. -y Displays the TCP connection template for all connections. Cannot be combined with the other options. interval Redisplays selected statistics, pausing interval seconds between each display. Press CTRL+C to stop redisplaying statistics. If omitted, netstat will print the current configuration information once. Process Exit Code 1. The step failed.
April 18, 2017 at 8:38 pm
It looks like all three are being piped into a single command so you are getting the help output. Try breaking them into separate steps.
Of course, this seems like a round peg for a square hole type of solution. I can't see a good reason to run this from an agent job.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2017 at 11:15 pm
Hi Anzz,
Instead of using CMD commands you can use below powershell script to achieve same.
$est = netstat -an | Select-String "ESTABLISHED" ; $est="Established : " + $est.count ;
$tw = netstat -an | Select-String "TIME_WAIT" ; $tw="Time_wait : " + $tw.count;
$cw = netstat -an | Select-String "Close_WAIT" ; $cw="Close_wait : " + $cw.count ;
$d= date
"************** $d **********************************" | Out-File E:\output.txt -Append
$est , $tw , $cw | out-File E:\output.txt -append
Remove-Variable est
Remove-Variable tw
Remove-Variable cw
Remove-Variable d
you can schedule above script in sql agent job or in windows task scheduler. Hope this script will work for you.
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply