Target server status constants interpret the return value of the Status property of the TargetServer object..
| Constant | Value | Description |
|---|---|---|
| SQLDMOTargetServerStatus_Blocked | 4 | Server running Microsoft® SQL Server™ is visible. SQL Server Agent is blocked. |
| SQLDMOTargetServerStatus_Normal | 1 | Server running SQL Server is visible. SQL Server Agent is known to be running. |
| SQLDMOTargetServerStatus_SuspectedOffline | 2 | Server running SQL Server is visible. SQL Server Agent execution state cannot be determined. |
| SQLDMOTargetServerStatus_Unknown | 0 | Network error prevents determination of referenced server and SQL Server Agent. |