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 |
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
 Posted - 2005-02-18 : 14:45:50
|
How do I configure security to allow users to execute a procedure that runs a job.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' GoThe users get a permissions error. You can do anything at www.zombo.com |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-02-18 : 17:59:48
|
| I was hoping some hard-core DBA would jump in on your last post about this.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45961In my opinion SqlJobs aren't something you really want to have users running. Multiple user couldn't run the job simultaneously anyway, why not just schedule it for as often as it needs to run? Alternatively, could you wrap the job steps in an SP and let the users bypass the job part of it and just run the SP?You could have ONE user be able to do what you asked about by:change the owner of a job to that user, grant exec on that SP to the same user, then that user could either launch the job via your SP or right out of enterprise manager.Be One with the OptimizerTG |
 |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2005-02-21 : 17:19:43
|
| Generally we only like to process this job at night as it is processor intensive, and has an impact on the applications it supports. However when their is high activity we may need to run this job during the day.I give that a try.Thank you.You can do anything at www.zombo.com |
|
|
|
|
|
|
Run Job from user account