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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-10-30 : 10:19:58
|
| Hi,1. What would be the impact if i change the owner of the scheduled job in SQL Server Agents.2. How to identify whether the job is "running" or not using Query - Job status?Thanks in advance |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-10-30 : 11:06:25
|
| 1. The owner of the job determines who can "see" and run the job. If you change the owner to SA, then only admins can see and run the job.2. One other way would be to launch "Job Activity Manager"EDIT:for 1) another consideration is what the job does. If you change the owner FROM sa to a user who doesn't have sufficient privs to perform the actions contained in the job then (I believe) the job will fail.Be One with the OptimizerTG |
 |
|
|
|
|
|
Changing owner and Job status