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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Security to run scheduled jobs?

Author  Topic 

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2005-02-15 : 14:26:43
How do I configure security to allow support users to run
this procedure that exists in a user database?

Create procedure usp_run_scheduled_job_cdb_to_angel as
exec msdb..sp_start_job @job_name = 'CDB_TO_ANGEL'

GO


You can do anything at www.zombo.com
   

- Advertisement -