Use one SQL server to monitor another one

Posted on 2011-05-12
Medium Priority
Last Modified: 2012-05-11
Does anyone know if it is possible to use one sql server to monitor another server and if that server goes offline run a job on the monitoring sql server to enable a local job?

Both servers are running SQL server 2005.
Question by:chrisdownes
  • 2

Accepted Solution

RGBDart earned 2000 total points
ID: 35752299
Yes. Let's say ServerA needs to watch over ServerB.

1) Create linked server on ServerA, that references ServerB
2) Craete Job on ServerA that will
  Step1. Select anything from that server. If Step 1 fails  - goto step 2. If Step 1 succedes - quit job.
  Step2. enable local job you mentioned

Just schedule the job - and here you go.

Expert Comment

ID: 35752303
Step1. Select anything from that server.
Step1. Select anything from that linked server which referencing ServerB.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question