How to schedule an sql agent job starting a SSIS Package from within a vb.net application?
Posted on 2012-04-13
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