Job.DeleteJobStepLogs Método (DateTime)
Deletes job step log files that are older than the specified date.
Espacio de nombres: Microsoft.SqlServer.Management.Smo.Agent
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public Sub DeleteJobStepLogs ( _
olderThan As DateTime _
)
'Uso
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
)
Parámetros
- olderThan
Tipo: System.DateTime
A DateTime value that specifies the log date, after which to delete the job step log files.
Ejemplos
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)
Vea también
Referencia
Sobrecarga de DeleteJobStepLogs
Espacio de nombres Microsoft.SqlServer.Management.Smo.Agent
Otros recursos
Programar tareas administrativas automáticas en el Agente SQL Server