Solved

How to schedule an sql agent job starting a SSIS Package from within a vb.net application?

Posted on 2012-04-13
3
536 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:Joar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 37841826
jbstp.Command = "dtexec /sq pkgOne /ser productionServer"

The following link shows all the parameters for DTSEXEC
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.90).aspx
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37846467
jbstp.Command = "dbo.sp_start_job 'Your SQL Server Agent Job Name Goes Here'"
0
 

Author Closing Comment

by:Joar
ID: 37856832
Did function! Thank you!
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question