No announcements
Found 1210112 threads
-
7 VotesPermissions to modify SQL Agent Jobs
this isn't correct. you can only modify jobs owned by that user. for modifying all jobs you will need sysadmin privsAnswered | 13 Replies | 61135 Views | Created by Ekbal Ansari (MCITP) - Tuesday, February 12, 2013 3:21 AM | Last reply by Abhishek0127[Abhishek kumar] - Thursday, August 27, 2015 2:54 PM
-
2 Votes
SQL Agent Job - Who modified job
Sorry, but SQL Server doesn't store this information, so you are out of luck.Answered | 2 Replies | 7863 Views | Created by Jeelani Kamal - Thursday, May 19, 2011 2:35 PM | Last reply by John Sansom - Thursday, May 19, 2011 4:04 PM -
0 Votes
SQL jobs permissions
There is no way to do what you describe with SQL Agent.Answered | 8 Replies | 2261 Views | Created by PrabhuB - Monday, September 21, 2015 8:57 PM | Last reply by Andreas.Wolter - Thursday, September 24, 2015 11:37 AM -
0 Votes
Permission issue ,Sql server Agent Job,SSMS
CONTROL Regards, kccrga -kccrga http://dbatrend.blogspot.com.au/Answered | 4 Replies | 4565 Views | Created by ken Myer - Thursday, August 10, 2017 1:54 AM | Last reply by kccrga - Tuesday, August 15, 2017 12:33 AM -
0 Votes
SQL Agent job modification
For more information, see: ...Answered | 5 Replies | 1531 Views | Created by sakurai_db - Friday, June 20, 2014 4:43 AM | Last reply by Sofiya Li - Monday, June 23, 2014 2:43 AM -
0 Votes
Grant permission on JOB in SQLagent inorder to modify steps in it
After that, you would like to be granted permissions to modify the job steps.Answered | 3 Replies | 1288 Views | Created by Dkuud - Wednesday, September 24, 2014 8:25 PM | Last reply by Dkuud - Thursday, September 25, 2014 5:38 PM -
0 Votes
sql agent job access
You can create a SP that runs the job and You can use "with execute as owner" to run the SP as the database owner.Here, The user don't need the permission on sp_start_job.Answered | 4 Replies | 6709 Views | Created by sqlguy10 - Wednesday, August 24, 2011 5:53 PM | Last reply by sqlguy10 - Thursday, August 25, 2011 11:37 PM -
0 Votes
Grant Agent Job Reader/Operator permission in SQL SERVER 2000
Hi Prasant, If you grant a user read access to SQL Server 2000 agent jobs by adding the user to TargetServersRole role in msdb, please ...Answered | 2 Replies | 3411 Views | Created by Prasant Pardesh - Friday, December 12, 2014 6:57 PM | Last reply by Lydia Zhang - Monday, December 15, 2014 7:58 AM -
0 Votes
sql agent jobs based on the database and the user
I want to give necessary permission to this user to view,create and modify sql agent jobs only in allowed databases.Answered | 1 Replies | 1077 Views | Created by Balckhat - Tuesday, August 12, 2014 7:37 AM | Last reply by Olaf Helper - Tuesday, August 12, 2014 8:34 AM -
0 Votes
SQL Server jobs permission
http://blogs.msdn.com/b/sqlagent/archive/2011/01/20/permissions-for-job-and-schedule-owners.aspxAnswered | 6 Replies | 9053 Views | Created by Ben Fosh - Monday, January 31, 2011 1:58 PM | Last reply by Sethu Srinivasan - Wednesday, February 2, 2011 7:45 PM -
0 Votes
Unable to change Job owner of the SQL Agent Job
-- Check permissions beyond what's checked by the sysjobs_view -- SQLAgentReader and SQLAgentOperator roles that can see all ...Answered | 10 Replies | 11889 Views | Created by NileshPatil - Wednesday, July 28, 2010 10:13 AM | Last reply by Davies, Paul - Tuesday, March 20, 2018 2:15 PM -
0 Votes
locking SQL agent job
https://msdn.microsoft.com/en-us/library/ms181362.aspx https://www.mssqltips.com/sqlservertip/1227/granting-permission-with-the-execute-as-command-in-Answered | 5 Replies | 913 Views | Created by etl2016 - Thursday, August 25, 2016 1:50 PM | Last reply by S_NO - Friday, August 26, 2016 1:54 AM -
0 Votes
SQL Server Agent Job
Adding to what Vaibhav said make sure you have sysadmin rights to create a job and see and modify others jobs.Answered | 5 Replies | 2049 Views | Created by GTanna - Wednesday, March 25, 2015 2:47 PM | Last reply by ryguy72 - Friday, April 3, 2015 6:26 PM -
0 Votes
Permissions to create a new schedule on an existing SQL Agent job
From the following official dociments, the SQL Server Agent database roles must have permissions on jobs and job schedules that they own.Answered | 2 Replies | 2721 Views | Created by Caitlin MacKay Shaw - Monday, April 21, 2014 9:26 PM | Last reply by Sofiya Li - Wednesday, April 23, 2014 1:55 AM -
0 Votes
SQL Server Agent for spacific job
Hi, If a job runs manually, but not through Agent, it is almost always a permissions issue with the SQL Agent Service account (Which is ...Answered | 1 Replies | 6425 Views | Created by Abdvip1 - Saturday, March 24, 2012 12:49 PM | Last reply by Pete A Carter - Author Pro SQL Server Administrati - Sunday, March 25, 2012 11:35 AM -
4 Votes
Understanding SQL Agent Jobs
Hi Dianne, ONLY a sysadmin can modify someone else's job.Answered | 5 Replies | 971 Views | Created by deescott - Monday, June 29, 2015 9:15 PM | Last reply by deescott - Tuesday, June 30, 2015 3:44 PM -
0 Votes
SQL Agent Job
So they cannot use the SQL Agent tools.Answered | 5 Replies | 5944 Views | Created by Manu_vmr - Monday, August 22, 2011 5:31 AM | Last reply by SQLWork - Tuesday, August 23, 2011 7:43 PM -
2 Votes
SQL Server Agent: view only permission for all jobs
Hi Uri, the SQLAgentReaderRole role grant permission to view all jobs, but allow a user amongst other things to create own job too.Answered | 9 Replies | 9662 Views | Created by Christian Heckelmann - Monday, July 25, 2016 4:32 PM | Last reply by Christian Heckelmann - Thursday, July 28, 2016 9:19 AM -
1 Votes
Permissions on SQL Server Agent
Before the roles were introduced we gave people permissions by denying and granting as needed.Answered | 8 Replies | 8596 Views | Created by Ludwig AR - Wednesday, October 19, 2011 8:57 PM | Last reply by Ludwig AR - Thursday, October 20, 2011 5:53 PM -
0 Votes
Issues in running SQL Agent Job
To check this, open your job, and go to steps.Answered | 6 Replies | 1498 Views | Created by GTalwar - Tuesday, May 14, 2013 10:36 AM | Last reply by Bhawesh Vithalani - Tuesday, May 14, 2013 12:29 PM - Items 1 to 20 of 1210112 Next ›
No announcements
