Run SQL Server 2000 Job programmatically
I know you can exec开发者_开发技巧ute a Job in SQL Server 2005/2008 by sending a call to the Stored Procedure msdb.dbo.sp_start_job.
However is it possible to do this programmatically for SQL Server 2000?
I am using VB.NET however I believe the language I'm using is irrelevant on how to go about it.
If someone knows how to do it in VB.NET (or C#, I can convert it), I'd appreciate it.
Edit: Appears it does exist in 2000. I couldn't locate it in Management Studio, MSDN for the 2005 "Other Versions" link only had 2005 and 2008, and google was only bringing up the 2005 version. Sorry for wasting people's time!
http://msdn.microsoft.com/en-us/library/aa260289(SQL.80).aspx
Suggests that sp_start_job is supported in SQL Server 2000
sp_start_job is available in 2000 as well.
精彩评论