开发学院数据库MSSQL Server 通过编程添加自动化作业 阅读

通过编程添加自动化作业

 2009-09-19 00:00:00 来源:WEB开发网   
核心提示: 2. 通过SMO的方式 这里有一个完整的介绍 http://msdn.microsoft.com/zh-cn/library/ms162162.aspx//Connecttothelocal,defaultinstanceofSQLServer.{Serversrv=default(Server

2. 通过SMO的方式

这里有一个完整的介绍

http://msdn.microsoft.com/zh-cn/library/ms162162.aspx

//Connect to the local, default instance of SQL Server. 
{ 
Server srv = default(Server); 
srv = new Server(); 
//Define an Operator object variable by supplying the Agent (parent JobServer object) and the name in the constructor. 
Operator op = default(Operator); 
op = new Operator(srv.JobServer, "Test_Operator"); 
//Set the Net send address. 
op.NetSendAddress = "Network1_PC"; 
//Create the operator on the instance of SQL Server Agent. 
op.Create(); 
//Define a Job object variable by supplying the Agent and the name arguments in the constructor and setting properties. 
Job jb = default(Job); 
jb = new Job(srv.JobServer, "Test_Job"); 
//Specify which operator to inform and the completion action. 
jb.OperatorToNetSend = "Test_Operator"; 
jb.NetSendLevel = CompletionAction.Always; 
//Create the job on the instance of SQL Server Agent. 
jb.Create(); 
//Define a JobStep object variable by supplying the parent job and name arguments in the constructor. 
JobStep jbstp = default(JobStep); 
jbstp = new JobStep(jb, "Test_Job_Step"); 
jbstp.Command = "Test_StoredProc"; 
jbstp.OnSuccessAction = StepCompletionAction.QuitWithSuccess; 
jbstp.OnFailAction = StepCompletionAction.QuitWithFailure; 
//Create the job step on the instance of SQL Agent. 
jbstp.Create(); 
//Define a JobSchedule object variable by supplying the parent job and name arguments in the constructor. 
JobSchedule jbsch = default(JobSchedule); 
jbsch = new JobSchedule(jb, "Test_Job_Schedule"); 
//Set properties to define the schedule frequency, and duration. 
jbsch.FrequencyTypes = FrequencyTypes.Daily; 
jbsch.FrequencySubDayTypes = FrequencySubDayTypes.Minute; 
jbsch.FrequencySubDayInterval = 30; 
TimeSpan ts1 = default(TimeSpan); 
ts1 = new TimeSpan(9, 0, 0); 
jbsch.ActiveStartTimeOfDay = ts1; 
TimeSpan ts2 = default(TimeSpan); 
ts2 = new TimeSpan(17, 0, 0); 
jbsch.ActiveEndTimeOfDay = ts2; 
jbsch.FrequencyInterval = 1; 
System.DateTime d = default(System.DateTime); 
d = new System.DateTime(2003, 1, 1); 
jbsch.ActiveStartDate = d; 
//Create the job schedule on the instance of SQL Agent. 
jbsch.Create(); 
} 

上一页  1 2 

Tags:通过 编程 添加

编辑录入:爽爽 [复制链接] [打 印]
[]
  • 好
  • 好的评价 如果觉得好,就请您
      0%(0)
  • 差
  • 差的评价 如果觉得差,就请您
      0%(0)
赞助商链接