23 September, 2010 Roel van Lisdonk 4 Comments 1 category

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();
        }
          
      }
    }

Tags:
Category: Uncategorized

4 Replies to “How to run an existing SQL Server Agent Job from C#”

  1. 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();
    }

  2. I am using sql server 2005. i am not able to find these namespaces
    using Microsoft.SqlServer.Management.Smo;
    using Microsoft.SqlServer.Management.Smo.Agent;
    using Microsoft.SqlServer.Management.Common;

    How to do it in Sql server 2005 using C# 4.0.

    Thanks for your help.

  3. using Microsoft.SqlServer.Management.Smo;
    //C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\microsoft.sqlserver.smo.dll
    using Microsoft.SqlServer.Management.Smo.Agent;//the same
    using Microsoft.SqlServer.Management.Common;
    //C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\microsoft.sqlserver.connectioninfo.dll

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts