且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何调用从Windows应用程序中的SQL Server代理工作

更新时间:2023-02-06 22:43:42

请给呼叫 sp_start_job

exec msdb.dbo.sp_start_job @job_name = 'YourJobName'

sp_start_job MSDN参考>

SqlConnection DbConn = new SqlConnection(YourConnectionString);
SqlCommand ExecJob = new SqlCommand();
ExecJob.CommandType = CommandType.StoredProcedure;
ExecJob.CommandText = "msdb.dbo.sp_start_job";
ExecJob.Parameters.AddWithValue("@job_name", "YourJobName")
ExecJob.Connection = DbConn; //assign the connection to the command.

using (DbConn)
{
    DbConn.Open();
    using (ExecJob)
    {
        ExecJob.ExecuteNonQuery();
    }
}