New Visual Basic Video Tutorial: Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - 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 SQL credentials?
• How can I force execution of the SSIS package with a certain account?
• What are proxies and proxy accounts in SQL?
• Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
• How to assign parameter values when you execute/call a SQL job for SSIS
  

and much more

---

• Source: http://www.LearnVBProgramming.com
• Category: Misc Topics That Don't Fit Anywhere Else
• Skill Level: 500 (Advanced)
• Length: 9:30 (10.5MB)
• 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: sql server proxy account, job credentials