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
Questions tagged [sql-job]
272 questions
2
votes
1 answer
How do I pass the SQL Server Job name to a stored procedure inside this job?
I have a job:
RunProcedures
It has steps:
Step 1: Do Something
Step 2: Do something Else
Step 3: Email
In step 3, I have:
EXEC spSendSuccessEmail -- and here's where I want to pass the job name.
Here's the code for the stored procedure above:
ALTER…
JJ.
- 9,580
- 37
- 116
- 189
2
votes
2 answers
running an exe file from a sql job
i'm trying to run an exe from a sql job.
the db is on the server, as well as the exe file.
the exe is supposed to write stuff on a log.
even though the sql job is successful, i see no change on the log file.
i've checked the exe locally, and it…
dusm
- 1,207
- 4
- 18
- 24
1
vote
1 answer
SQL server job owner account password change impact
I have around 20 jobs running in SQL Server 2008. The owner of this account is Domain\Administrator. Now there is need for changing password for administrator. I'm just wondering if this change will have any impact on jobs.
Please help me clarify…
pramodtech
- 6,300
- 18
- 72
- 111
1
vote
2 answers
Alternative for SQL Job scheduling
We've a simple set of stored procedures that we use for data import in our SQL 2005 db. There's going to be a master SP which will trigger those SP one by one. In past we have used SQL Agent and scheduled a job which in-turn executes the Master…
Hemant Tank
- 1,724
- 4
- 28
- 56
1
vote
1 answer
Best Way to Monitor SQL Server Agent Job Step
What is the best practice to monitor SQL Server job steps?
I have a single job with 50 steps. Sometimes, some of the steps are taking longer to complete. I want to have a monitoring process that notifies me when a step takes longer than usual. The…
Data 2020
- 33
- 3
1
vote
0 answers
Failed to acquire connection SSIS
I am executing a SSIS package from SQL job. I am getting following error time to time.
Execute SQL Task:Error: Failed to acquire connection "<>".
Connection may not be configured correctly or you may not have the
right permissions on this…
udaya726
- 1,010
- 6
- 21
- 41
1
vote
1 answer
SFTP file transfer error - connecting to an unknown server and add its host key
I have created the batch to transfer the file using SSH keys, I checked the public and private key mapping on both the servers and it's working fine.
My Windows batch code using SFTP command is as follows:
open sftp://sftp_user@ssh_dest_server…
Irfan
- 665
- 6
- 29
1
vote
3 answers
Powershell Script using Invoke-SQL command,needed for SQL job, the SQL Server version of Powershell is somewhat crippled, is there a workaround?
Full Question: Have Powershell Script using Invoke SQL command, using snappins, I need them to be included in a SQL job, the SQL Server version of Powershell is somewhat crippled, does anyone know a workaround?
From what I have gathered, SQL…
Jerome
- 267
- 4
- 15
1
vote
1 answer
How to start an sql job by completion of other sql Jobs?
I have 5 sql jobs. But I have to start the 5th sql job only when all other 4 sql jobs are been completed. Is it possible to achieve it?
Thanks in Advance,
Anish
- 219
- 2
- 12
1
vote
2 answers
SSIS Deployed Project validates Succesfully even with wrong Kingswaysoft Connection parameters
I deployed a SSIS project with a pre-configured Kingswaysoft connection, a project connection.
I created different environments inside the SSISDB database, and I want to validate the project with every one of them.
I intentionally set wrong…
Aleix
- 431
- 4
- 20
1
vote
0 answers
Message 'EXECUTE AS USER' failed for the requested user 'xxx' in the database 'yyy'. The step failed
Googled enough and found some solutions for this error which did't help me. All I am trying to do is:
Created a stored procedure:
create procedure test
as
begin
update dummytable set dummycolumn = 'abcd'
end
Created a job - 'testjob' and run…
Rick
- 1,392
- 1
- 21
- 52
1
vote
1 answer
SQL Job not running. Error: Could not obtain information about Windows NT group/user 'Domain\username', error code 0x2
We have an old server with several SQL jobs running fine (with specific domain users).
We have migrated everything to a new server, but found out that the jobs are not running.
The error is:
The job failed. Unable to determine if the owner…
Zahmatra
- 29
- 6
1
vote
1 answer
How to use Environment File in SSIS Job Step Property
Created a package and deployed on SQL Server 2017. my package is having parameters (package level scope) and want to set values from environment file at the time of create a SQL-JOB-STEP.
I have created environment file and defined my variables…
Haseeb
- 746
- 7
- 22
1
vote
1 answer
Unable to execute SSIS Package from SQL Server Agent Job I get error " The command line parameters are invalid"
When I am trying to execute a SSIS package from the SQL Server Agent Job, I get this error:
Executed as user: WEATRUST\Prod_SSIS_Service.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.7462.6 for 64-bit
Copyright (C) Microsoft…
jisto
- 19
- 1
1
vote
2 answers
SSIS package executes fine from my machine, but failing as a SQL job
I have an SSIS package which uses C# script and 3rd party libraries to perform the required task. The package executes fine from visual studio, however when I try to run the same as SQL job, I see a successful completion, however the task the script…
Ishika
- 11
- 1