New SQL Server Integration Services Video Tutorial: Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job

Pt. 8 - How to Execute a SQL Server SSIS-Based Job Remotely Using sp_start_job - view details

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

---

• Source: http://www.LearnIntegrationServices.com
• Category: Package Execution and Scheduling
• Skill Level: 500 (Advanced)
• Length: 15:30 (14.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: dts package, execute package, msdb, sql agent, jobs