Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-12-29 : 18:19:51
|
Greetings!I would like a way for users to be able to run SSIS packages not on schedule but on demand. What would be the best to handle this as far as the security they will be running this under?Right now I have the followingCREATE PROCEDURE dbo.usp_StartAgentJob @SQLJobName VARCHAR(100) = NULL WITH EXECUTE AS 'DOMAIN\big_kahuna_user'AS BEGIN EXEC msdb.dbo.sp_start_job @SQLJobName; -- END END Then give user rights to that stored procedure.Is there a better way?Thanks!<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
SSIS on demand