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 |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-01-23 : 18:51:36
|
| Hi AllI am migrating the jobs from SQL Server 2000 scheduler to an external tool called AppWorks. Networking team maintains this Appworks Scheduler.I need to provide Appworks - Server name, job name, user id, password etc. My doubts1) Which user id will I provide? - I dont want to create an id in the sysadmin group as the Networking team will have admin access on the database. 2) Is there any way out ..like creating an id which has just the stored procedure sp_start_job access or just job execute access? 3) If I can create an id with just job execute access, is there any drawbacks like ..if the job is updating one of the tables..will it error with an access denied issue? For the jobs which i am planning to migrate, the job owner is sa. Please help.Thanks in advanceSreenath |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-23 : 20:56:55
|
| AFAIK, a job when running will run under the account that owns it whomever starts/invokes it.you can try and create an account, grant that account execute on sp_start_job, logon to QA with that account and execute the spHTH--------------------keeping it simple... |
 |
|
|
|
|
|
Access to the jobs