Stack Overflow
Stack Overflow

Questions tagged [sql-agent]

SQL agent, also known as SQL server agent, is a Microsoft SQL server relational database management system (RDBMS) background tool. SQL agent allows the database administrator (DBA) to schedule automated execution jobs, as well other management or value-added database tasks such as backups.

SQL agent, also known as SQL server agent, is a Microsoft SQL server relational database management system (RDBMS) background tool. SQL agent allows the database administrator (DBA) to schedule automated execution jobs, as well other management or value-added database tasks such as backups.

SQL agent is an integral part of Microsoft’s SQL Server. It runs as a windows service only and allows for the handling of a wide variety of tasks such as backup automation, database replication setup, job scheduling, user permissions and database monitoring.

208 questions
78
votes
9 answers

how to know status of currently running jobs

I need to know if a given Job is currently running on Ms SQL 2008 server. So as to not to invoke same job again that may lead to concurrency issues.
TonyP
  • 5,655
  • 13
  • 60
  • 94
29
votes
4 answers

How can I view full SQL Job History?

In SQL Server Management Studio, when I "View History" for a SQL Job, I'm only shown the last 50 executions of the Job. How can I view a full log of every execution of a SQL Job since it was created on the server?
Curtis
  • 101,612
  • 66
  • 270
  • 352
14
votes
2 answers

SQL Agent job failure with SSIS package to Access DB

I have an SSIS package that runs a script task (mostly, and a few other things). The script task connects to an Access database using an OleDB connection. This is the Microsoft Jet 4.0 connection. I have the drivers installed. But it won't run in…
siride
  • 200,666
  • 4
  • 41
  • 62
8
votes
5 answers

SQL Server Agent - get my own job_id

I'm running a SQL Server 2008 64 bit Developer Edition with Service Pack 1 installed. I have a SQL Server Agent Job. Within this job I want to get the job_id of my own job. On MSDN (http://msdn.microsoft.com/en-us/library/ms175575(v=SQL.100).aspx)…
Helmut Rothtauscher
  • 133
  • 1
  • 1
  • 5
7
votes
4 answers

SQL Server Agent Job Running Slow

I am executing a stored procedure using SQL Server Agent Job in SQL Server 2005. This job was running fast until yesterday. Since yesterday this job is taking more than 1 hour instead of 2 mins. I executed the stored procedure in SSMS, it just…
Prateek
  • 231
  • 3
  • 6
  • 12
7
votes
4 answers

SQL SERVER Agent stops working Automatically

I have been experiencing a strange issue for last few weeks. On my two different servers the sql server Agent stops working automatically, All I have to do is to restart the agent and is back on running. But because it stops working it misses the…
M.Ali
  • 67,945
  • 13
  • 101
  • 127
6
votes
2 answers

How to synchronize SQL Server Agent jobs across availability group replicas on Linux?

I have two SQL Server 2019 instances running on Linux. These two instances both contain a single database which is synchronized using AlwaysOn Availability Group. Data in the database is synchronized, but the problem is that the SQL Agent jobs are…
Andrej Lucansky
  • 725
  • 10
  • 17
6
votes
5 answers

SQL Server Agent and SSIS packages

I'm trying to pass a variable value from SQL Server Agent job to SSIS package but the variable contains an apostrophe in it causing the SQL Server Agent job to fail e.g In SQL Server Agent at Job Step Properties I'm entering the following…
JamesMillner
  • 71
  • 4
6
votes
1 answer

SSISDB not found and can not create New catalog in SQL Server 2012

I just installed SQL Server 2012, I want to create a catalog in Integration Services Catalog in order to obtain SSISDB database but I got the following error Any help would be most appreciated.
amani92
  • 903
  • 8
  • 22
6
votes
1 answer

Query to list the job names and step associated with a particular table

Is there any way to search and find ,what job holds a particular table refresh . There are multiple sql agent jobs with multiple steps.What is the sql query to search all jobs and locate the job name and steps? This is to identify the steps…
user1254579
  • 3,901
  • 21
  • 65
  • 104
5
votes
2 answers

Alter failed for ProxyAccount 'yyy' (Microsoft.SqlServer.Smo)

I am running into an issue when trying to script the creation of a credential and related proxy in Microsoft SQL Server Management Studio. My script is the following: CREATE CREDENTIAL xxx WITH IDENTITY = 'domain\xxx', SECRET = '*******'; EXEC…
Cody
  • 161
  • 7
5
votes
1 answer

Error Executing SQL Server Agent Job: JSON text is not properly formatted, Unexpected character '"'

Using Microsoft SQL Server 2016 (RTM) Standard Edition, I am trying load a JSON into a SQL Server table using a SQL Server Agent Job, and get the following error: JSON text is not properly formatted. Unexpected character '"' is found at position…
Prospec007
  • 51
  • 1
  • 3
5
votes
1 answer

Where does a Remote SSIS package actually run

We have a legacy Sql Agent job that runs on Server A. The job Step points to a SSIS package on Server B. In which environment does that package actually run? We assume that it executes in the environment of the agent that calls it, but because of…
Aeroradish
  • 371
  • 1
  • 5
  • 11
4
votes
1 answer

SQL Server Web Edition SSIS

SSIS designer and runtime is not part of SQL Server 2014 Web edition. Does this mean SSIS packages cannot be run as scheduled jobs on web edition via SQL Agent even if written on SSIS from the Developer version?
skittle
  • 131
  • 10
4
votes
1 answer

Increase TEXT SIZE in SQL Server Agent

SQL Server Agent has a 512 characters limit on texts fields like nvarchar(max). I found this out after seeing my stored procedure is working correctly when I run it in SSMS but not working when is being run by a SQL Server job. To fix this I know I…
Bahman
  • 1,034
  • 12
  • 28
1
2 3
…
13 14