sql-agent-job Questions
8
Solved
On a SQL 2016 Server I have a job that calls an SSIS package. That package is in a project in the SSISDB and has parameters. One of those parameters is a string type that is blank as a default.
I ...
Gaberlunzie asked 5/12, 2017 at 20:56
3
Solved
I have created SSIS package which is running successfully and dumping the data to the required place. But the same package results in the error when i run it through job. I googled n got these link...
Jetport asked 27/5, 2013 at 4:43
3
Solved
SSIS job has failed and posting the below error
[Product Sales [749]] Error: An exception has occurred during data insertion, the message returned from the provider is: The given value of type Str...
Airless asked 31/1, 2018 at 21:31
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
4
SQL Server Reporting Services, in SSRS it seems like Schedules never fire, however a look at the SQL Agent reveals a permission issue related to not being able to resolve a user account.
Seems SQL...
Uralian asked 15/12, 2009 at 4:28
3
I'm trying to create a job that will run based on the online status of a database. For example, step 1 will check if the database is online; if the database is online, it will run the rest of the s...
Frolicsome asked 1/5, 2012 at 0:16
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
3
Solved
The Scenario
There are certain SQL Agent Jobs that are scheduled to run every few minutes throughout the day.
There are legitimate times when it will miss its next schedule because it's still run...
Raddle asked 23/5, 2012 at 19:30
3
Solved
I have the below code (only the portion that is needed)
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'SomeStep',
@step_id=1,
@cmdexec_success_code=0,
@on_success_ac...
Muckworm asked 10/4, 2012 at 12:3
8
Solved
I have faced with the following issue: when trying to send email with results of query attached as file, using sp_send_dbmail via executing ordinary query everything seems to be working OK.
But if...
Multi asked 27/2, 2013 at 13:5
1
Could you suggest please how to create SQL Server Agent job for a stored procedure that have 1 input parameter?
The procedure is correctly created and i executed it using this code :
EXECUTE dbo...
Motorman asked 25/2, 2016 at 17:3
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
1
Solved
I'm trying to Partition a Table by both Year and Month. The Column through which I'll partition is a datetime type column with an ISO Format ('20150110', 20150202', etc).
For example, I have sale...
Rialto asked 10/8, 2015 at 15:55
3
Solved
I'm currently using code like this to detect if a SQL server job is running. (this is SQL Server 2005, all SP's)
return (select isnull(
(select top 1 CASE
WHEN current_execution_status = 4 THEN...
Zing asked 2/5, 2011 at 19:2
1
Solved
I have noticed that SQL Agent does not start automatically after a reboot/shutdown on a few of our servers (SQL server starts up fine). The service is set to automatically start in windows. W...
Sikkim asked 2/9, 2014 at 9:20
2
Solved
I need to export the data from a particular table in my database to Excel files (.xls/.xlsx) that will be located into a shared folder into my network. Now the situation is like this -
I need to ...
Impetus asked 27/9, 2013 at 9:20
5
Solved
What I need to do is export data into CSV file using T-SQL.
And I'm very confused about there are many ways can do it, I don't know to choose which one, please help me to confirm the bollowing:
A...
Dozy asked 24/9, 2012 at 14:45
5
I have been trying to find sample code with using SQL Server 2005, I need to start an Agent Job and wait until it finishes process and then get the success or failure.
I know that I can use
EXE...
Coh asked 18/5, 2012 at 7:29
1
Solved
I have a Maintenance plan under SQL Server 2008 R2 which runs at midnight. Within this maintenance task, there is no notify operator task. Within the SQL Agent job that executes the maintenance pla...
Chuckchuckfull asked 21/9, 2012 at 10:25
2
I don't want to hit the database frequently based on page request, so I planned to create a xml file using separate C# coding [exe file] & put in the common path to access from different page/p...
Hopfinger asked 1/8, 2012 at 6:52
3
Solved
I have a piece of code that needs to run every day at a specified time. The code right now is sitting as a part of my web application. There are 2 stored procedures to get/save data that the code u...
Camden asked 11/7, 2011 at 15:6
1
© 2022 - 2024 — McMap. All rights reserved.