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)

public void DeleteJobStepLogs(
	DateTime olderThan
)

Parameters

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

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)

Community Additions

ADD
Show: