Share via


Job.DeleteJobStepLogs Method (DateTime)

Deletes job step log files that are older than the specified date.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Sub DeleteJobStepLogs ( _
    olderThan As DateTime _
)
'Usage
Dim instance As Job 
Dim olderThan As DateTime

instance.DeleteJobStepLogs(olderThan)
public void DeleteJobStepLogs(
    DateTime olderThan
)
public:
void DeleteJobStepLogs(
    DateTime olderThan
)
member DeleteJobStepLogs : 
        olderThan:DateTime -> unit
public function DeleteJobStepLogs(
    olderThan : DateTime
)

Parameters

  • olderThan
    Type: System.DateTime
    A DateTime value that specifies the log date, after which to delete the job step log files.

Examples

The following code example deletes all job step log files that were created after March 15th, 2009.

C#

Server srv = new Server("(local)");
Job jb = srv.JobServer.Jobs["Test Job"];
DateTime deleteDate = new DateTime(2009, 3, 15, 9, 45, 52);
jb.DeleteJobStepLogs(deleteDate);

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = $srv.JobServer.Jobs["Test Job"]
$deleteDate = new-object System.DateTime(2009, 3, 15)
$jb.DeleteJobStepLogs($deleteDate)

See Also

Reference

Job Class

DeleteJobStepLogs Overload

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Scheduling Automatic Administrative Tasks in SQL Server Agent

Automated Administration Tasks (SQL Server Agent)

sp_delete_jobsteplog (Transact-SQL)