sql-agent Questions
5
Solved
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 creat...
Rattlepate asked 13/10, 2011 at 12:49
10
Solved
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.
Ithunn asked 26/8, 2013 at 13:52
4
Solved
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 ru...
Ahasuerus asked 18/12, 2013 at 14:27
2
Solved
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 synchroniz...
Denature asked 26/8, 2020 at 5:48
1
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 ...
Streusel asked 26/6, 2015 at 1:40
1
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 forma...
Fist asked 10/4, 2018 at 16:40
1
Solved
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.
...
Particolored asked 14/2, 2019 at 9:26
1
Solved
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 na...
Iain asked 31/5, 2018 at 10:37
2
Solved
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. ...
Polly asked 3/11, 2016 at 18:22
4
Solved
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. ...
Detachment asked 16/8, 2011 at 20:7
2
Solved
I have a SQL Server 2008 SSIS job which executes some Win 32 exe files. This job runs fine when i execute the job through BIDS (On Windows 2008 box). Now i have deployed the package in MSDB databas...
Psychodiagnosis asked 16/10, 2011 at 19:34
1
© 2022 - 2024 — McMap. All rights reserved.