Get ping result of multiple server into SQL table

Note:  Best viewed in Internet Explorer 6 and above Implementation: How to get ping result of multiple servers into SQL table. Scenario: Lets say you manage multiple DB servers solely and in your day to day monitoring activities list,you have to first check all server running status by pinging them. So how will you achieve this?? will you ping all servers individually and manually or would you … Continue reading Get ping result of multiple server into SQL table

Get SQL Server Jobs detail history based on last run day and time

Note:  Best viewed in Internet Explorer 6 and above Implementation: How to get SQL Server Jobs detail history based on last run day(no of days) and time(minutes) Scenario: Lets find out SQL Server Jobs detail history based on last run day(no of days) and time(minutes) Infrastructure:The below query/procedure has been run/tested successfully on sql server 2005,2008,2008 R2 and 2012. Steps: Mostly you can find out the SQL server jobs … Continue reading Get SQL Server Jobs detail history based on last run day and time