Stack Overflow
Stack Overflow

Questions tagged [sql-server-agent]

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.

From Microsoft.com:

SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand.

483 questions
0
votes
0 answers

How can I view all the details in a SQL Server agent job history log entry?

I am trying to view the details of a SQL Server agent job history log entry. What I am seeing is the following: Date 2/1/2021 8:30:01 AM Log Job History (Every 10 Minutes Transaction Log Backup.Subplan_1) Step ID 1 Server …
jlavallet
  • 1,267
  • 1
  • 12
  • 33
0
votes
1 answer

SQL Server Agent Error - Exception has been thrown by the target of an invocation

I am doing a script task in SSIS and scheduling the task using SSIS Agent. I am able to execute the Script task successfully but I am getting an error when I am trying to run it through SQL Server Agent - Error Error: 2020-11-13 12:31:29.64 Code:…
Abdulquadir Shaikh
  • 13
  • 4
0
votes
1 answer

SSIS: Accessing Sharepoint UNC via SQL Server Agent Job

I have an SSIS package connection that connects to a Sharepoint site w/ a UNC path, like so: \\[Site URL]\DavWWWRoot\sites\DTS_BURM\DARBenchmarks\FileName.csv My package reads the file and imports it into the SQL DB. This process works fine in VS.…
Michael S Palatsi
  • 91
  • 1
  • 9
0
votes
1 answer

Import requests ModuleNotFoundError: No module names 'requests'

I want to schedule a python script in SQL Server and I have followed this questions and it's solution in the answers When I run the job it fails and throws this error: import request ModeulNotFoundError: No module named 'requests' I tried pip…
Vatsal Patel
  • 73
  • 1
  • 1
  • 5
0
votes
1 answer

Unable to open step output file for one job only

I have several SQL Server Jobs which successfully write the output of the job to a local drive on the server. I created a new job today using the exact same path, the job is succeeding but I get the message [SQLSTATE 01000] (Message 0) Unable to…
Lee
  • 13
  • 1
  • 4
0
votes
1 answer

WinSCP hangs after uploading files to SFTP

I have a SSIS package. Package has an Execute Process Task. Execute Process Task has a Executable property set as C:\Program Files (x86)\WinSCP\WinSCP.exe and Argument property set as below: /console /command "open…
Jay Desai
  • 821
  • 3
  • 15
  • 42
0
votes
1 answer

SQL Server Job date output different than output in SSIS debug run

So we have a SQL job which converts data into a certain date output in a CSV file. This always worked perfectly. Recently we migrated to another SQL Server, and now the problem is this, the query used to transform date and time into the specific…
Nebur
  • 3
  • 1
0
votes
1 answer

Reoccurring SQL job to run on the 2nd and 4th Thursday of every month

I need a job to run on the 2nd and 4th Thursday of every month. I know I can set up a job to run every two weeks but that logic doesn't work when a month eventually hits a five week span. Is it possible to set this up using the SQL Server Agent…
justair07
  • 37
  • 8
0
votes
1 answer

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR with Code: 0xC020901E

I have an SSIS package that runs perfectly fine on Visual Studio 2013 but when I deploy the package to SQL server agent and execute it there I get the following error: Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "Lookup"…
kunmuli
  • 1
  • 4
0
votes
0 answers

How to lock a database while a SQL Server Agent is running a job

I need to be able to lock a SQL database while a set of end of day stored procedures are running within a SQL server agent job. This needs to happen so that a series of checks that occur at the end of day aren't affected by new data. The checks…
Damian Jacobs
  • 488
  • 6
  • 21
0
votes
1 answer

maintenance job frozen in executing state

I have several maintenance job stuck on my sql server , stuck from the 10th of may , what should I do first? I try to stop them from sql agent but nothing happens I did a check with sp_whoisactive have this kind of statments…
Gabriele D'Onufrio
  • 405
  • 1
  • 5
  • 17
0
votes
1 answer

SQL Server Agent Job will not complete, no indication job even started, no error messages

Agent in SQL Server 2016, running on Server 2014. SSIS project developed in VS 2015, runs as expected. Single node executes simple SQL. Package is deployed via DeploymentManifest, deployed to ‘SQL Server’. Deployed package runs as expected when…
HenryFramer
  • 33
  • 6
0
votes
0 answers

My SQL Server Agent job is running for long time and failing with Login issues

Please see the logs shown below for more information: 2020-04-23 13:13:56.97 spid10s Starting up database 'tempdb'. 2020-04-23 13:13:57.42 spid10s The tempdb database has 4 data file(s). 2020-04-23 13:13:57.42 spid10s The tempdb database…
mallikarjun appani
  • 1
  • 2
0
votes
0 answers

Which "Run As" to choose in SQL Server Agent T-SQL job step

I have a SSIS package that I want to run in SQL Server Agent T-SQL job using Stored Procedure since I have a permission issue described in my other post: Using Proxy to give SQL Server Agent windows credential to access to azure db not…
Shannon Lin
  • 1
  • 1
0
votes
1 answer

Start SQL Server jobs (say job 2 and job 4) after ensuring that the job1completed successfully

I have SQL Server Agent jobs - Job 2 and Job 4 that need to run only after the database restore (Job 1) is completed. Job 1 applies updates to the database and is critical and time consuming. So, I am not looking to add any other step in this…
Bina
  • 3
  • 2
1 2 3
…
32 33