开发者

Run SQL job from Ruby on Rails App

Is it possible开发者_如何学C to run a SQL job from Ruby on Rails application?


You can connect to the SQL Server's msdb database and call sp_start_job just like any other stored procedure.

EXEC msdb.dbo.sp_start_job 'Myjob'

There is also a way with VBScript that I have not tried. Both solutions are documented here: http://www.mssqltips.com/tip.asp?tip=1730

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜