Server Explorer Node

Go Up to Understanding the Explorer Tree Hierarchy

The Server node provides access to server-centric information or resources.

Explorer node location

DBArtisan places Server as the first level of information under the datasource node in the Explorer.

Sub-nodes and Platform Availability

Expanding this node provides access to the following nodes:

	MySQL	PSTGRS *	SQL SVR	SYB ASE	SYB IQ
Version Explorer Node	✓	✓	✓	✓	✓
Databases Explorer Node	✓	✓	✓	✓	✓
Configuration, Engine Configuration, or Database Configuration. For details, see Working with Configuration/initialization Parameters.	✓		✓	✓	✓
Scheduling	✓
SQL Server Agent			✓
Server Triggers. For a support summary for this object type, see Server Triggers			✓
Error Logs. For a support summary for this object type, see Error Logs			✓
Logs Explorer Node		✓

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

Version Explorer Node

DBArtisan places Version under the Server node of the Explorer. When you select Version, DBArtisan shows version information about your datasource in the right pane of the Explorer window.

Platform availability and Explorer node location

MySQL	Server> Version
PSTGRS *	Server> Version
SQL SVR	Server> Version
SYB ASE	Server> Version
SYB IQ	Server> Version

Toolbar or Right-click actions

For details on actions available from the Explorer, see Initiating Object Actions in the Navigator/Explorer.

SQL Server Agent

DBArtisan assists you in using the Microsoft SQL Server Agent service to automate administration of a Microsoft SQL server. Microsoft SQL Server Agent manages, and schedules, allowing programmed responses to server events or the execution of scheduled administrative tasks. Automating recurring administrative tasks and responses to server events can save considerable time for other administrative tasks.

Platform availability and Explorer node location

SQL SVR

Server> SQL Server Agent

Sub-nodes

Expanding this node provides access to the following nodes:

• Alerts
• Jobs (Oracle)
• Logs (SQL Server Agent)
• Operators

For a support summary for those object types, see Supported Objects.

Note: Before using SQL Agent elements from DBArtisan, consult the Microsoft SQL Server documentation for a detailed understanding of the prerequisites, operational requirements, and functionality provided by that service. For more information, see Accessing Third Party Documentation.

Logs Explorer Node

On PostgreSQL datasources, the Logs node provides access to logging output files.

Platform availability and Explorer node location

PSTGRS *

Server> Logs

Toolbar or Right-click actions

For details on actions available from this node, see Rotate Log.