How to open the Support Services drilldown
From the Spotlight Client
- Select the connection from the left Connections pane.
- Click Monitor | Support Services from the ribbon.
About the Support Services drilldown
SQL Agent Jobs page
Investigate jobs that are defined, their current status and the latest execution message.
SQL Agent Jobs grid
Lists all SQL Server Agent Jobs that are defined in this server and their current status.
Failed jobs are highlighted with a red “X” icon, successfully completed jobs are shown with a green “check” icon, and jobs that are currently running are shown with a blue “!” icon.
To start a job from the grid, select the job and click Start Job. Membership of the Spotlight Diagnostic Administrators group is required to perform this operation.
Job History grid
Shows the execution messages for each step in a job. Job messages may not be available for all jobs.
SQL Agent Jobs Status chart
Shows the status of jobs over time, making it easy to determine when a job ran, and when it succeeded or failed.
When a job runs, Spotlight adds it to this chart (Running), identifying the time it started.
When the job finishes, Spotlight checks the completion status (Success or Failure) and changes the color of the job accordingly, making it easy to see exactly when a job started and ended.
Take Offline - This makes a cluster resource or cluster group unavailable. For example, taking the SQL Server resource offline will stop the MSSQLServer service. This option is available only for groups and resources that are currently online. Additionally, you cannot take a resource offline if that would cause the SQL Server, to which Spotlight is currently connected, to be taken offline.
Bring Online - Starts a cluster resource or group. This is the opposite of Take Offline. This option is available only for resources and groups that are offline.
Move Group - Moves a cluster group to another node of the cluster. This will prompt you for the machine that the group should be moved to. All cluster resources in this group will be brought online on the node you specify.
Full Text Search page
Shows performance details for all full-text indexes on the server. In full-text indexing, a separate catalog is maintained that indexes each word in a database field as a separate index entry.
If some of the details are incomplete for all of the rows, the Full Text Search Service may not be running. Check the Services Status grid on the Service Status page to confirm this.