Stack Overflow
Stack Overflow

Questions tagged [sql-job]

A job is a specified series of operations performed sequentially

Jobs define an administrative task that can be executed one or more times (manually or via a schedule) and monitored for success or failure each time it executes

272 questions
2
votes
2 answers

Most efficient way to move table rows from one table to another

I've created a denormalized table that needs to be inserted/updated every hour. The process is rather involved from a data perspective, so i am looking for a recommend way to update the table without disrupting the users. i am thinking of having a…
Marco
  • 2,453
  • 3
  • 25
  • 35
2
votes
1 answer

What happens to Jobs scheduled when SQL Server Agent is stopped?

On our SQL Server theres a SQL Job which is ran every hour. On one particular hour it doesn't seem like the SQL Job was ran, and that was due to the SQL Server Agent being stopped during a backup. If SQL Server Agent has been stopped, are the jobs…
Curtis
  • 101,612
  • 66
  • 270
  • 352
2
votes
1 answer

Sql jobs failed randomly to acquire connection after the activation of the Always ON feature

Since we activated the Always On mode on our server, we have some issues regarding our SQL jobs (running SSIS package) which failed randomly with this message : Failed to acquire connection "DB". Connection may not be configured correctly or you…
ElRoro
  • 203
  • 1
  • 13
2
votes
0 answers

How to generate XMLA script of an SSAS tabular model using SQL job?

We are using SQL jobs to deploy SSAS models deployed in UAT server to production server. Two steps we are currently following are: Sync model of UAT to production. Process (full) the production model. Now we want to add another step where we take…
NewDevNinja
  • 21
  • 1
2
votes
1 answer

Pass parameters from SQL Server Agent job to SSIS Package on Step "set value"

I have an SSIS package that will be run in a another database and has some parameters that will depend on the environment in which will be running (database name, FilePath for an excel file, ServerName, etc) and I want to set these in a way that…
Baldie47
  • 1,148
  • 5
  • 16
  • 45
2
votes
0 answers

Running SQL Agent Jobs with Always Encrypted Column

I am experimenting and exploring always encrypted feature in SQL Server 2016 in local database. As part of the experiment, I tried to apply the feature in SQL Server Jobs. I did below steps, but I am getting error. I have written a stored…
Sruthy John
  • 21
  • 6
2
votes
1 answer

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER- have tried everything

I have created a SSIS package and I am trying to run it locally. We use package configurations that point to sql tables and a XML config file. The package ran successfully for about a week, even when deployed to a SQL Server Agent Job in our STAGE…
Netta G
  • 53
  • 1
  • 5
2
votes
0 answers

SQL Job step wont fail when Powershell does

I currently have a two step SQL job that's intention is to do the following; 1) Check file exists. (issue lies here) 2) Run SSIS package to import a csv file to a database. $File = "\\File\File2\Text.csv" if(!(Test-Path -Path $File)) { Write-Error…
user2261755
  • 159
  • 1
  • 3
  • 17
2
votes
2 answers

SSIS Package is not executing from SQL Agent Job

I am trying to create a scheduled job, which should be executed daily at 23:15 o'clock. If I execute my package from Visual Studio it is working fine and it fills my Excel-files. But this is only working, when I do it manually. If I execute my…
malue
  • 59
  • 2
  • 10
2
votes
1 answer

Best method for an ETL Package to load all data initially and then next run to only load changes or new items

I am new to SSIS and would like the best method for an ETL package creation to load all data initially and then next run to only load changes or new items. I will use the package on a schedule SQL job. I know that I could set SSIS package to…
Brian Tran
  • 115
  • 10
2
votes
1 answer

change run 64 bit run time property to false on run time executing ssis package through sql server job

I have parent package and associated child package to be executed from sql server agent job but I am getting following error : * Source: xxxxx Connection manager "RedshiftODBC" Description: An ODBC error -1 has occurred. End Error Code:…
user2431858
  • 63
  • 12
2
votes
1 answer

SQL job fails when user is not logged into the server

I have currently one issue with a SQL job that always fails when the user is not logged in into the server. The job is configured to run with a specific service account that has rights on the server our sql-server is in. When i remote connect to the…
Pedro Lopes
  • 479
  • 2
  • 9
  • 20
2
votes
1 answer

How to stop a SQL job showing 'In Progress' status?

I am using SQL Server 2014 and I have a job (called ITB) which has been scheduled to run at 4.00am on a daily basis. The SQL job has 11 steps in it. At 09.00 am this morning, I noticed that the job was showing 'In Progress' in the job history. It…
user3115933
  • 4,303
  • 15
  • 54
  • 94
2
votes
1 answer

How to find SQL job which is aggregating data between 2 tables

So I got a list of jobs in my server and 2 tables that one of those jobs is aggregating. Lets say in table "A" there is a rows of purchase receipts, and in table "B" its info that is used by other procedures lets say purchase price/VAT/etc.. So my…
Petras Paludnevičius
  • 29
  • 3
2
votes
1 answer

SMSS shows job in msdb but not under SQL Server agent

I have a stored procedure that starts a job. When I go to [Databases] -> [System Databses] -> [msdb] -> [Tables] -> [System Tables] I can see the job in [dbo].[sysjobs] and everything related to this job is there in the msdb tables, and I've tested…
Parth K.
  • 21
  • 2
1 2
3
…
18 19