代码调用SQL Server代理任务的两种实现方式

using Microsoft.SqlServer.Management.Smo;
/// 列出某个服务器上面所有的代理作业
/// 
private void btList_Click(object sender, EventArgs e)
/// 双击运行某个作业
/// 
private void lstJobs_MouseDoubleClick(object sender, MouseEventArgs e)
{
Job item = lstJobs.SelectedItem as Job;
item.Start();
} 

USE msdb ;
GO 
EXEC dbo.sp_start_job N'THINKER-demo-demo_products_merge-THINKER-1' ;
GO