Link to home
Start Free TrialLog in
Avatar of Joar
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
ASKER CERTIFIED SOLUTION
Avatar of Barry Cunney
Barry Cunney
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Anthony Perkins
jbstp.Command = "dbo.sp_start_job 'Your SQL Server Agent Job Name Goes Here'"
Avatar of Joar
Joar

ASKER

Did function! Thank you!