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 SSISand much more Source: http://www.learnitfirst.com/Course/189/Video/1257/sp-start-job-Options-Credentials-and-Proxy-Accounts.aspx Course: http://www.learnitfirst.com/Course/189/C-Sharp-2005.aspx Skill Level: 500 (Advanced) Length: 9:30 (10.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: sql server proxy account, job credentials
This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.
