C中的SQL作业结果#

我有一个使用SQL Server代理在服务器上以编程方式运行远程包的小代码。但代码的问题是,即使作业出来是失败的,但作业被成功执行。所以这个程序总是可以正常工作。

我想知道我是否能在C中捕捉到工作结果。有什么想法吗?

namespace LaunchSSISPackageAgent_CS
{
  class Program
  {
static void Main(string[] args)
{
  SqlConnection jobConnection;
  SqlCommand jobCommand;
  SqlParameter jobReturnValue;
  SqlParameter jobParameter;
  int jobResult;

  jobConnection = new SqlConnection("Data Source=(local);Initial Catalog=msdb;Integrated Security=SSPI");
  jobCommand = new SqlCommand("sp_start_job", jobConnection);
  jobCommand.CommandType = CommandType.StoredProcedure;

  jobReturnValue = new SqlParameter("@RETURN_VALUE", SqlDbType.Int);
  jobReturnValue.Direction = ParameterDirection.ReturnValue;
  jobCommand.Parameters.Add(jobReturnValue);

  jobParameter = new SqlParameter("@job_name", SqlDbType.VarChar);
  jobParameter.Direction = ParameterDirection.Input;
  jobCommand.Parameters.Add(jobParameter);
  jobParameter.Value = "RunSSISPackage";

  jobConnection.Open();
  jobCommand.ExecuteNonQuery();
  jobResult = (Int32)jobCommand.Parameters["@RETURN_VALUE"].Value;
  jobConnection.Close();

  switch (jobResult)
  {
    case 0:
      Console.WriteLine("SQL Server Agent job, RunSISSPackage, started successfully.");
      break;
    default:
      Console.WriteLine("SQL Server Agent job, RunSISSPackage, failed to start.");
      break;
  }
  Console.Read();
}

}