远程调用SQL SERVER AGENT 里的JOB,如何判断其调用是否成功,是否完成
如题,在C#里远程调用 SQL SERVER AGENT 里的JOB
如何判断其调用是否成功,是否完成
SqlConnection jobConnection;
SqlCommand jobCommand;
SqlParameter jobReturnValue;
SqlParameter jobParameter;
int jobResult;
try
{
jobConnection = new SqlConnection("Data Source=SHNI310;Initial Catalog=msdb;Persist Security Info=True;User ID=sa;Password=password1$");
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 = "TestSSISJob";
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;
}
}
catch (Exception ex)
{
string s = ex.Message;
}
这个代码只是返回是否开始调用成功
但是调用的结果
什么时候调用完毕 这些怎么才能知道哦?