SQL Server Performance Forum – Threads Archive
Rights to run SQL jobs
Hi guys, Do you need to have sa rights to run jobs? i suspect not, if not what access rights do you need in sql server to be able to run jobs? prompt response much appreciated. Thanks MHi,<br />no you can create it without SA rights too , please refer , sp_add_job in this regards in BOL.<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
If that job is owned by the SYSADMIN group then you must be part of it, otherwise you can create and manage your own jobs. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Have a look at the TargetServersRole role in the msdb database. Not sure if things have been tightened security-wise in sp4 regarding this role. Karl Grambow www.sqldbcontrol.com
What rights do i need to have to be able to create and manage my own jobs? apart from having sa rights…
what rights do you need to have to be able to run dts jobs?
Hi,<br />have you read Satya’s post ?! you can create your own job even if you dont have a SA right but ensure that job is not owned by Sysadmin group.<br /><br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami<br />
]]>