开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜