Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets the date and time when the job was last modified.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property DateLastModified As DateTime
Get
'Usage
Dim instance As Job
Dim value As DateTime
value = instance.DateLastModified
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public DateTime DateLastModified { get; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property DateTime DateLastModified {
DateTime get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DateLastModified : DateTime
function get DateLastModified () : DateTime
Property Value
Type: System.DateTime
A DateTime value that specifies the date and time when the job was last modified.
Examples
The following code example creates a new job and displays the date on which it was last modified.
C#
Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.Create();
Console.WriteLine(jb.DateLastModified);
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb.Create()
Write-Host $jb.DateLastModified
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Automated Administration Tasks (SQL Server Agent)
Scheduling Automatic Administrative Tasks in SQL Server Agent