c# - How to invoke the job in SQL Server agent from windows application

Question

I've scheduled a job xyz in the SQL Server Job Agent. Now I want to invoke the job from my windows application.

Answer 1

Make a call to sp_start_job.

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

MSDN Reference on sp_start_job

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