Joar
asked on
How to schedule an sql agent job starting a SSIS Package from within a vb.net application?
I have a SSIS package stored on a remote SQL server 2008 database (web).
From a .net web application (running on another web server) I would like to schedule this db stored SSIS package as a sql agent job to run on a specified point of time.
I have the code for creating the SQL Agent job, and that functios.
It is something like this:
....
Dim jbstp As JobStep
jbstp = New JobStep(jb, strJobb & "_Step1")
jbstp.Command = "?????"
But how do I specify the SSIS package which is stored on the remote in the remote SQL server 2008?
The SSIS package will also need some parameters
From a .net web application (running on another web server) I would like to schedule this db stored SSIS package as a sql agent job to run on a specified point of time.
I have the code for creating the SQL Agent job, and that functios.
It is something like this:
....
Dim jbstp As JobStep
jbstp = New JobStep(jb, strJobb & "_Step1")
jbstp.Command = "?????"
But how do I specify the SSIS package which is stored on the remote in the remote SQL server 2008?
The SSIS package will also need some parameters
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
jbstp.Command = "dbo.sp_start_job 'Your SQL Server Agent Job Name Goes Here'"
ASKER
Did function! Thank you!