September 24, 2003 at 9:48 am
From within an SQL statement can you call a VB application?
September 24, 2003 at 10:01 am
only by "shelling" out with xm_cmdshell or by interfacing with it as a COM object with sp_oacreate.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 25, 2003 at 7:50 am
Not only ...
You can create the package with Execute Process Task, schedule the job, disable this job and call it within store procedure using
sp_start_job 'Job Name'.
You must be SQL DBA or sa and run same account what is SQL Server Agent does, or if not you have to be an owner for that job and your sa must create the Proxy account for you on SQL Server Agent to run this job.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply