How to run an existing SQL Server Agent Job from C#

 

If you want to execute an existing Microsoft SQL Server Agent Job in C# you an use the following function:

The function uses SQL authentication to connect to the Microsoft SQL Server instance.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.Agent;
using Microsoft.SqlServer.Management.Common;
using System.Data;
 

public override void Execute()
    {
      Server server = new Server(@"MyServer\MyInstanceName");
      try
      {
        server.ConnectionContext.LoginSecure = false;
        server.ConnectionContext.Login = "MyName";
        server.ConnectionContext.Password = "MyPassword";
        server.ConnectionContext.Connect();
        Job job = server.JobServer.Jobs[Name];
        job.Start();
      }
      finally
      {
        if (server.ConnectionContext.IsOpen)
        {
          server.ConnectionContext.Disconnect();
        }

      }
    }

 

Add this after the above method to have the Job wait until it’s done

Thread.Sleep(5000);
job.Refresh();
while(job.CurrentRunStatus != JobExecutionStatus.Idle)
{
Thread.Sleep(5000);
job.Refresh();
}


Reference: http://www.roelvanlisdonk.nl/?p=1736

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值