I have created a number of jobs that call SSIS pacakges to import data and stuff. In Excel I've set up an interface that lets me run these jobs by calling stored procedures that call the jobs, etc. Works perfect. Yay! But...
When I had another user test this out it fails. Well it turns out that nobody else can see the jobs that I've created. The whole point of this project is for other users to be able to run this. Doh!
Is there some special way that I'm supposed to call the jobs so that any user can call them?
This is what I have in my stored procedure:
EXEC msdb.dbo.sp_start_job N'CapCostFore_Job_ImportAcctWalk'
The step in the job that calls the package is set to run as SSIS_Proxy.
Thanks!
When I had another user test this out it fails. Well it turns out that nobody else can see the jobs that I've created. The whole point of this project is for other users to be able to run this. Doh!
Is there some special way that I'm supposed to call the jobs so that any user can call them?
This is what I have in my stored procedure:
EXEC msdb.dbo.sp_start_job N'CapCostFore_Job_ImportAcctWalk'
The step in the job that calls the package is set to run as SSIS_Proxy.
Thanks!