共用方式為


TargetServer.TimeZoneAdjustment 屬性

Gets the difference, in minutes, between the local time midnight on the target server and midnight Coordinated Universal Time (Greenwich Mean Time).

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property TimeZoneAdjustment As Integer 
    Get
'用途
Dim instance As TargetServer 
Dim value As Integer 

value = instance.TimeZoneAdjustment
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int TimeZoneAdjustment { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property int TimeZoneAdjustment {
    int get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member TimeZoneAdjustment : int
function get TimeZoneAdjustment () : int

屬性值

型別:System.Int32
An Int32 value that specifies the number of minutes time difference between the referenced target server and Greenwich Mean Time.

備註

The LocalTime property and the TimeZoneAdjustment property can be used to correctly schedule multiserver administration tasks where the master server and the target server are in different time zones.

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

TargetServer 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_help_targetserver (Transact-SQL)