TargetServer.TimeZoneAdjustment Property
Gets the difference, in minutes, between the local time midnight on the target server and midnight Coordinated Universal Time (Greenwich Mean Time).
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property TimeZoneAdjustment As Integer
Get
'Usage
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
Property Value
Type: System.Int32
An Int32 value that specifies the number of minutes time difference between the referenced target server and Greenwich Mean Time.
Remarks
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.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace