Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

On the the Instances tab  tab, you can find the a list of all your registered instances, their most important information of their status and their jobs. 

...

  • Instance name - displays the name of the registered SQL Server instance. 
  • Status Status - displays the status of the SQL Server instance. The status could be: Unknown, UpOnline, Connection Failure, Unsupported SQL Server Version, Authentication Failure, or Error.
  • Agent Status -  displays the status of the SQL Server Agent services of the respective instance. The agent status could be: Running, Stopped, Stopping, Starting, or Unknown. 
  • SQL Server Version - displays the version of the SQL Server instances. 
  • # of Jobs - displays the total number of jobs on each instance.
  • #  of Failed Jobs - displays the displays the total number of jobs which last run outcome was failed.
  • Owner - displays the owner specified for each instance  instance.
  • Location - displays the location specified for each instance. 
  • Edition - displays the edition of the SQL Server instances.
  • Actions - displays a gear icon where you can find the actions you can perform on a single instance or on several selected onesinstances. To find more information, go to What actions you can perform on a single instance? or What bulk actions can you perform on several instances?.
To find more information about what actions you can perform on a single or several selected instances, go to What actions you can perform on a single instance? or What bulk actions can you perform on several instances?
Tip

Keep in mind:

  • You can sort the information available on this tab by clicking the column header by which you want to order your instances.
If you want to view more specific information, you can use the filters available on the left side of this tab. To find more information, go to Filtering your instances information.
Tip
  • Click the Image Added icon to select the information you want to hide or show on the Instance list view.

On the left section of the Instances tab, you can find the Filter Table By section that allows you to filter your information according to your requirements. For more information about these options go to Filtering your instances information.

How do you add SQL Server Instances?

To add new SQL Server instances to your environment, go to the top menu options of this tab, and click click Add SQL Server instanceInstance; the wizard for registering instances opens. Go to to Registering new SQL Server instances for  for more information. 

How do you export information available on the Instances tab?

To export the information displayed in the current view of your your Instances tab tab, go to the top menu options of this tab and click click Export. Specify the format you want to use for the exported document: PDF, CSV, or XML.

How do you refresh information on the Instances tab?

Whenever there is new information to be updated on the Instances  tab, the option Refresh  (located on the top of this tab) becomes available so you can click and update it to the latest information. you want to update the information presented on the Instance list, click on the Image Added Refresh icon.


Scroll pdf ignore
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...