The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
35 views

Execute stored procedure in another server from sql agent job

I am trying execute stored procedure in remote server in sql agent job using sqlserver 2008 r2 select * from openquery([1.1.1.1],'exec [DB_Name].[dbo].[sp_ProcName]') Or EXEC ...
0
votes
2answers
62 views

SQL Server Permissions

I have create a user and grant many permissions and roles to it including SQLAgentUserRole and SQLAgentReaderRole. My application check the status of agent if it is running or not and whenever I am ...
-2
votes
0answers
31 views

log shipping backup job getting failed frequently

Even i am facing similar issue some of the log backups are getting failed for the same reason stated above the first possibility that came to my mind was the same it could have been a network issue or ...
1
vote
1answer
34 views

SQL Server Agent cannot log on to “MyServer”

I'm struggling to get our SQL Server Agent to run a maintenance plan, which used to work in the past. (This is on SQL Server 2008 R2.) The original problem was that the SQL Server Agent would not ...
2
votes
2answers
73 views

SQL Job step run as different sql account

I'm curious how to set up a SQL job step to be executed as a different SQL login account. It appears I need to set up a New Proxy Account which requires an existing credential. When I create a ...
5
votes
2answers
369 views

Does the Sql Server Agent account need sysadmin permission?

I ran Brent Ozar's sp_blitz script, and one of the things it's complaining about is that my SQL Server Agent account has sysadmin permission. I removed the sysadmin permission, but then the agent ...
1
vote
1answer
67 views

Script to see running jobs in SQL Server with Job Start Time

how to write script to see running jobs in SQL Server with Job Start Time? SELECT sj.name, sja.run_requested_date, CONVERT(VARCHAR(12), sja.stop_execution_date-sja.start_execution_date, 114) ...
3
votes
1answer
55 views

SQL server job has not run and also no entry logged in its history

I have scheduled a SQL job to run daily at 3am in the morning which creates a batch. It has not run today and i am also not able to fathom what's the reason behind its failure. There is no entry in ...
3
votes
1answer
84 views

How do I get SQL Server agent to show up in SSMS for a non-sysadmin user?

I have already mapped the user to the msdb database and assigned him the role of SQLAgentOperatorRole, but the user still can't see the SQL Server Agent listed when he connects. The Agent show up fine ...
1
vote
1answer
196 views

SSIS execute task running wscript.exe hangs when started from SQL Server Agent

I have a problem with sql server 2012 SSIS package which has execute step running wscript.exe utility. When I run this package from BIDS everything works fine, when I start package from SSIS it also ...
0
votes
3answers
597 views

Cant see SQL Server Agent in SSMS [duplicate]

I have SSMS 2012 installed on my laptop, and SQL Server 2012 on my hosting, but when i try to schedule a sql job i didn't find "SQL Server Agent" in the left side list!!?
0
votes
1answer
102 views

what server role that needs to be configured for the user to enable sql server agent

I'm on SQL SERVER 2008, I want to enable the SQL Agent for a particular user, who has only read access to the database. I don't want to give sysadmin role? Is there any way, I can do this?
2
votes
3answers
671 views

Check if SQL Agent job is being executed manually

I have a stored procedure that performs database backups. Because I'm looking at Availability Groups within SQL Server 2012 I want to utilise the *sys.fn_hadr_backup_is_preferred_replica* function ...
-2
votes
1answer
213 views

How to run steps in one job sequentially [closed]

I have one job on SQL server Job Agent that has 3 steps. I want to the job to run starting with step one. After step one is complete and only when it completes I want step 2 to start running and so ...
0
votes
3answers
557 views

SQL agent job step's connection managers

Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
3
votes
2answers
561 views

Can I delegate SQL Agent rights without granting sysadmin rights?

I'd like to give a user the ability to administer SQL Agent jobs. According to the doc page, I can do this by granting the "appropriate" roles on msdb. I've granted all three SQLAgent% roles, but ...