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

SSIS package fails but SQL Server Agent marks success

I have a SQL Server Agent job with two steps: Executes an SSIS package with a task for importing a CSV and another task for sending an email saying that the import was successful. The step's On Failure action is set to Quit the job reporting…
fdkgfosfskjdlsjdlkfsf
  • 3,165
  • 2
  • 43
  • 110
0
votes
1 answer

SQL Server Integration Package Conversion Error only when calling from job, not when executing in SQL Server Data Tools

Maybe somebody can provide assistance for the following question: I have a SSIS package with Target SQL Server Version 2014. I am not 100% sure which version my target server is running, but it is at least 2014, but i assume its 2016. I have…
Monty Burns
  • 101
  • 1
  • 3
  • 10
0
votes
0 answers

Use Single Server to run SQL Server Agent Jobs for all environments

We have a dedicated server to run SQL Server Agent jobs for each environment (ie., DEV, QA, STG,...). We almost have 20 environments. Looks like the table below. So currently we have 20 servers for running jobs in each environment. Now we are in…
StackUser
  • 5,370
  • 2
  • 24
  • 44
0
votes
1 answer

SSIS execution aborting on partial completion without error message

In Visual Studio 2019 we are running 2 SSIS packages that return millions of records. When the DTSX packages are started separately in SSIS Catalog or SQL Server Agent only 3700913 and 3623554 records (much fewer than the expected amount) are…
John
  • 1
0
votes
0 answers

SQL Server Agent Database Restore Job Failure

An SSA database restore job fails sporadically with this error: String data, right truncation [SQLSTATE 01004] This job runs daily, and succeeds most of the time. When it fails it is on a Friday and it leaves the database in a restoring state. The…
Unnamed DBA
  • 35
  • 6
0
votes
1 answer

sql server agent job frequency set to 3 seconds

I would like to setup a SQL Server agent job to run every 3 seconds, but I found that the minimum frequency is 10 seconds. Then I try to setup multiple schedules, such that first schedule starts at 00:00 (run every 10 seconds), second schedule…
hosir
  • 477
  • 1
  • 9
  • 33
0
votes
1 answer

Validating the SSIS config files configured on the SQL Server Agent Jobs

Recently I faced an issue in SQL Server Agent Job. The error is "Login Time Out Expired". I have analyzed it. It seems like the server name mentioned on the SSIS config file is wrong. I have corrected the server name now the job runs fine. Our job…
StackUser
  • 5,370
  • 2
  • 24
  • 44
0
votes
2 answers

SQL Server Deployed SSIS package won't open files despite SA account having access to folder

I posted a similar question before, but I have now came back to the point where I need to deal with this and after some tuning I have managed to get rid of all the errors, except one warning that basically tells me that the path provided to the…
Coda759
  • 107
  • 14
0
votes
2 answers

SQL Server Agent: Can't Start, Won't Start - Changing the 'Log On' account to a Managed Service Account

Overflow Community, I have an issue I have been butting my head against for hours upon hours now. I have scoured Google for solutions and tried (what feels like) them all. In an attempt to bring our TEST environment more in line with our PROD…
L.Newell
  • 102
  • 1
  • 2
  • 13
0
votes
0 answers

Can't use google packages on SQL Server Agent Jobs?

I have a Python Script that gets a BigQuery query to a Pandas Dataframe and then exports to my SQL Server Database. I can run that perfectly on a Jupyter Notebook, but when I run the script on SQL Server Agent it gives the error "No module named…
Cookye
  • 23
  • 4
0
votes
0 answers

Error 7303,7412 occurred while creating job in SQL Server using Microsof.ACE.Oledb.12.0

I can manually run the stored procedure, but when I create job in SQL Server Agent, it is not running, execution failure. SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0 xml;IMEX=2;HDR=YES;Database=C:\Excel\LanConnection.xlsx;', …
Karthik
  • 91
  • 2
  • 13
0
votes
0 answers

Permissions to edit jobs without sysadmin rights

NT group (created for developers) has login with the Sysadmin role on the Prod server to be able to execute, update, create, etc … SQL Server Agent jobs, run SSIS packages etc. New requirements, that developers should not be sysadmin and not to be…
yoelbenyossef
  • 393
  • 1
  • 7
  • 26
0
votes
0 answers

SQL Server Agent Connection showing wrong Server

I have inherited another SQL database (Version 15.0.4083.2) and have noted some problems with the SQL Agent. Specifically the Agent is not logging any jobs (as I just discovered trying to check logs to debug an issue). I am seeing the following…
Matthew Baker
  • 2,637
  • 4
  • 24
  • 49
0
votes
1 answer

Is it possible to switch between SSIS data sources when calling a SSIS package using File System in SQL Server Agent?

Having now added a like for like DB to do UAT on to our server I have run into a problem with our SSIS Packages. They are stored as files and as such we use File System in SQL Server Agent to run them on a schedule. I now need to run these packages…
Will
  • 228
  • 1
  • 2
  • 15
0
votes
0 answers

Can I pass a parameter to a SQL Agent job?

I am using SQL Server 2017. I can call a SQL Agent job named MySQLAgent_Job using the below SQLCMD SQLCMD -E -SMySQLServer -Q "msdb.dbo.sp_start_job N'MySQLAgent_Job'" Is it possible to pass in a parameter to MySQLAgent_Job thru this command…
faujong
  • 949
  • 4
  • 24
  • 40
1 2 3
…
32 33