共用方式為


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 Agent 排程自動管理工作

自動化管理工作 (SQL Server Agent)

sp_delete_jobsteplog (Transact-SQL)