开发者

Run SQL job from Ruby on Rails App

开发者 https://www.devze.com 2023-01-10 23:16 出处:网络
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.

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

精彩评论

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