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 …

Continue reading Get ping result of multiple server into SQL table

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. …

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