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
精彩评论