Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · C# Training Videos · SQL Server Video Training
   
Visual Basic Training Videos
Visual Basic Video Tutorial Home  Subscriber Videos  

Visual Basic Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

   Chapter: Misc Topics That Don't Fit Anywhere Else
Download! Skill Level: 500 (Advanced)
Duration: 15:30
Size: 14.0MB
Versions/Editions Covered: SQL Server 2005 , SQL Server 2008 , SQL Server 2000
Added/Updated: Sep 26, 2007

Download this video
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are the pros and cons of using transact-sql to execute SSIS packages?
  • Why would I even want to execute a scheduled job remotely?
  • What can't I do if I execute a job remotely?
  • What are the msdb fixed database role memberships a user must have to execute a job?
  • What msdb security options should I know about?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
and much more
Tags for this video: dts package execute package jobs msdb sql agent  
< Back Download this video
People Who Downloaded this Video Also Downloaded:
TitleSkillDownload
Pt. 1 - Getting Started With Your First ASP.NET Website in Visual Basic 200 Download
Pt. 2 - Adding Objects and Working With Events, Properties and More 200 Download
Pt. 4 - Using Gridviews, SQL Server 2005, and Hacking Your Textboxes 300 Download
Pt. 1 - Creating the Project, Adding Items to the WinForm and More 100 Download
Pt. 3 - An Overview of the Toolbox and Design-Time vs. Runtime 200 Download
This video is part of the following video series: "A Tour of the Various Ways to Execute an SSIS Package Outside of BIDS and SSMS"
First - acronym definition time: BIDS is the Business Intelligence Development Studio and SSMS is the SQL Server Management Studio. Now - what does this series cover? This series is a high-level overview of how to execute packages outside of the normal BIDS and SSMS techniques of executing them interactively and through jobs. You'll learn the various techniques of executing such as .NET execution through C# and Visual Basic, using DTEXEC.exe, sp_start_job and SMO-based execution, and how to use web services with SSIS to execute packages remotely.
To view all videos in this series, click here

About the Instructor:
Scott Whigham Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)

   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/20/2008 7:13:26 PM