No announcements
Found 2765979 threads
-
0 Votessql 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 | 1026 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
Map Drive in SQL agent Job
And the job fail this time, and look into the log, it still ask me to put user name and password.Answered | 7 Replies | 5153 Views | Created by sakurai_db - Monday, June 24, 2013 8:12 AM | Last reply by sakurai_db - Tuesday, June 25, 2013 4:10 PM -
0 Votes
SQL jobs permissions
The main reason why a job owned by SA can only be managed by a member of sysadmin is because otherwise it would expose your system to an escalation of privileges: The ...Answered | 8 Replies | 2195 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
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account
The owner does not have to be sa, based on my test, as long as the owner has a sysadmin server role, the agent job runs.Answered | 5 Replies | 980 Views | Created by junidev - Thursday, November 17, 2016 12:29 PM | Last reply by Eric__Zhang - Friday, November 18, 2016 9:10 AM -
0 Votes
Is it possible to run ssis package from stored procedure by non sysadmin user using concept of proxy account?
If you create an Agent Job which runs the SSIS, then change the stored proc to run "sp_start_job jobname", and it will run as the ...Answered | 3 Replies | 2346 Views | Created by Digvijay Mahida - Thursday, January 10, 2013 5:41 PM | Last reply by Tom Phillips - Thursday, January 10, 2013 8:04 PM -
1 Votes
Limit SQL agent jobs based on User rights...
Hello, Instead of giving them direct access to create jobs, use your own stored procedures and only give each team rights to execute their 'view' ...Answered | 2 Replies | 1377 Views | Created by Roshall - Tuesday, May 7, 2013 8:09 PM | Last reply by Sean Gallardy - Tuesday, May 7, 2013 10:06 PM -
0 Votes
executing xp_subdirs as non-sysadmin
When you are sysadmin, SQL Server accesses the share with its own credentials.Answered | 4 Replies | 9187 Views | Created by phil_e - Wednesday, February 19, 2014 10:10 AM | Last reply by Erland Sommarskog - Friday, February 21, 2020 8:47 PM -
0 Votes
Unable to change Job owner of the SQL Agent Job
Another thought, is the working/misbehaving instances using the same service accounts for sql agent and sql instances?Answered | 10 Replies | 11784 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
Agent Job's Run As for SSIS Job Type
I have SQL Server Agent service running under a domain account that is a sysadmin on SQL Server.Answered | 5 Replies | 1368 Views | Created by GoodOldFashionedLoverBoy - Wednesday, January 23, 2013 3:34 PM | Last reply by ArthurZ - Wednesday, January 23, 2013 7:16 PM -
1 Votes
Deny permission to run sql agent jobsto sysadmin users.
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and ...Answered | 3 Replies | 1298 Views | Created by Abhishek Tondwalkar - Tuesday, December 10, 2013 1:39 PM | Last reply by Uri Dimant - Wednesday, December 11, 2013 6:52 AM -
2 Votes
How to get the SQL Signon that Agent Jobs "Run As" or "Executed as User"
Jobs are created by sysadmins.Answered | 17 Replies | 1605 Views | Created by TheBrenda - Saturday, May 2, 2015 7:19 PM | Last reply by TheBrenda - Saturday, May 23, 2015 3:25 PM -
0 Votes
SQL Agent fails to run job
sorry for layover, had mandatory training to attend; used fully qualified path error has changed to: Executed as user: NASE\SQL-IIS.Answered | 10 Replies | 3560 Views | Created by Pacce - Monday, February 6, 2012 2:37 PM | Last reply by Pacce - Wednesday, February 8, 2012 12:59 PM -
2 Votes
User Interface to start SSIS Jobs or SQL Agents
SQL Agent Jobs don't have parameters.Answered | 11 Replies | 2270 Views | Created by Basti087 - Monday, June 15, 2015 12:48 PM | Last reply by Visakh16 - Wednesday, June 17, 2015 1:15 PM -
0 Votes
sql agent not able to run ssis unless sql agent account is owner of job
I added the Built In\Administrator group to the sysadmin sql role....now I'm able to run sql job not owned by the account running sql agent ...Answered | 7 Replies | 4613 Views | Created by Anonymous123sdaf - Wednesday, September 25, 2013 6:58 PM | Last reply by Harry Bal - Thursday, September 26, 2013 1:37 AM -
0 Votes
Filtered access to agent jobs
SQL jobs are managed through MSDB database.Answered | 1 Replies | 1295 Views | Created by John DBA - Wednesday, January 1, 2014 11:11 AM | Last reply by Neha Mahajan DBA - Thursday, January 2, 2014 5:57 AM -
2 Votes
SQL SERVER AGENT JOBS NOT FOUND
Do you have sysadmin privileges on the SQL server?Answered | 3 Replies | 3318 Views | Created by Rajasekhar.R - Monday, January 30, 2012 6:30 AM | Last reply by Biztalk-learner - Monday, January 30, 2012 8:00 AM -
0 Votes
sql agent job getting file access denied error
It was the ID running the agent.Answered | 2 Replies | 1884 Views | Created by GoodOldFashionedLoverBoy - Monday, December 16, 2013 8:28 PM | Last reply by GoodOldFashionedLoverBoy - Monday, December 16, 2013 9:20 PM -
1 Votes
Monitor or prevent deletion of SQL agent jobs??
But wasn't the question about Agent jobs?Answered | 18 Replies | 1441 Views | Created by tlyczko2 - Monday, March 20, 2017 1:49 PM | Last reply by Lin Leng - Friday, March 24, 2017 5:51 AM -
0 Votes
Stored Procedure is not executing through SQL Agent job
Hey, Finally my problem got resolved, my stored procedure'll get information from all the servers, the account which i was using it doen't have proper ...Answered | 5 Replies | 3706 Views | Created by sunkavelli - Tuesday, October 9, 2012 8:48 PM | Last reply by sunkavelli - Tuesday, October 9, 2012 10:56 PM -
0 Votes
Permissions to create a new schedule on an existing SQL Agent job
Usually, there are three fixed database roles which give administrators finer control over access to SQL Server Agent, including SQLAgentUserRole, ...Answered | 2 Replies | 2632 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
No announcements
