Share via


Job.DeleteJobStepLogs 方法 (DateTime)

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

命名空间:  Microsoft.SqlServer.Management.Smo.Agent
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
Public Sub DeleteJobStepLogs ( _
    olderThan As DateTime _
)
用法
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
)

参数

  • olderThan
    类型: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)

请参阅

参考

Job 类

DeleteJobStepLogs 重载

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

其他资源

在 SQL Server 代理中计划自动管理任务

自动执行管理任务(SQL Server 代理)

sp_delete_jobsteplog (Transact-SQL)