sql-server-agent Questions
6
Solved
I have a SQL Server Agent Job that previously had two steps. Today, I've had to integrate the third step, and soon I'll need to integrate a fourth.
I want to be sure that the step will execute prop...
Nazi asked 20/6, 2011 at 14:39
8
I'm trying to set up a Stored Procedure as a SQL Server Agent Job and it's giving me the following error,
Cannot bulk load because the file "P:\file.csv" could not be opened. Operating system err...
Determinable asked 21/10, 2013 at 10:17
3
I have a running SQL Server image on Docker, however I need to enable SQL Server Agent to run some jobs, but I have not succeeded. The main problem is that the container has quite a few databases a...
Scalene asked 3/9, 2021 at 0:30
7
Solved
I have a Job setup in SQL Server 2008 which sends a notification email to one operator when the job fails.
Question: Is it possible to setup a notification email being sent to multiple operators ...
Menedez asked 15/9, 2011 at 13:22
7
Solved
I have a single step job that executes a stored procedure. I would like get the date of the last successful job execution time so that I can just update a delta instead of the whole set of data.
...
Dorman asked 21/1, 2010 at 20:57
8
There's been a string of random occurrences of the following error in the SQL Server Agent scheduled jobs lately that I have been unable to find a solution to.
The error occurs infrequently, but ...
Thompson asked 16/7, 2014 at 13:53
6
I am trying to get SQL Server Agent to run a program with arguments (as a Operating system CmdExec job step), but everytime it runs the job I receive the following error: The process could not be c...
Desiredesirea asked 24/6, 2014 at 19:22
4
Solved
I have a scripted SQL Server Agent job I'm trying to transfer over to my local database from a server, but I receive this error message:
Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line...
Cassidycassie asked 2/11, 2011 at 16:3
3
Solved
I have installed SQL Server 2016 Express edition and also installed SSMS 18.4, now I am having an issue while restarting the SQL Server Agent service.
I am able to login with my system user, but ...
Blastoderm asked 8/11, 2019 at 7:45
4
Solved
I use sp_start_job to start a job.
The job (test2) has only one step:
select getdate()
waitfor delay '00:00:10'
The TRY/CATCH code:
begin try
EXEC msdb.dbo.sp_start_job @job_name = 'test2'
en...
Classify asked 27/3, 2013 at 12:37
9
Solved
I am creating a SQL Server Replication using a script. When I try to execute
The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Cou...
Eschar asked 5/8, 2009 at 17:13
3
Solved
My server is down and I can only get the harddisk from it. I found my database and copied it but where I can find agent jobs? Where are they saved?
Automatic asked 8/10, 2012 at 17:27
4
Solved
The MSSQLSERVER service on Local Computer started and then stopped. Some services stop automatically
I have created one sample of node js . But when I start the application is going to connection of sql server then not give response by sql server.
When i going in service panel and start sql serve...
Nibble asked 29/1, 2016 at 8:52
3
Solved
I'm getting the following error when trying to read a SQL Job.
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'
How can I fix this?
Weldon asked 16/6, 2011 at 11:14
4
Solved
I have an SSIS Package stored in the MSDB database which works fine when I execute it. It will run under SA account or will use Windows security.
I want to schedule this job to run with SQL Agent,...
Wasson asked 9/4, 2009 at 8:37
2
Solved
This is for very first time that I am trying to use SQL server Agent.
I get this error :
Msg 22022, Level 16, State 1, Line 0
SQLServerAgent is not currently running so it cannot be notified of t...
Dub asked 22/3, 2015 at 15:27
6
I need to create an application for monitoring SQL Server 2000 Agent Job status and info when Job occur same as show on Windows application event log. Now I connect to the database already via a co...
Armpit asked 21/9, 2010 at 4:35
2
Solved
Is it possible to enable or disable the sql server agent using t-sql?
Homiletics asked 19/4, 2012 at 18:3
7
Solved
Can I (How do I) configure Sql Server 2008 to notify an operator if any step in the Job fails?
I have a Sql Server job with several steps to update data from multiple different sources, followed b...
Hileman asked 4/10, 2010 at 19:35
5
I am unable to kill some SQL Server agent jobs. The task state continues to be running and the command stays in KILLED/ROLLBACK. The job executes queries against OSI's PI system via OLEDB linked se...
Swab asked 8/6, 2012 at 13:59
2
Solved
I have many jobs that have a step to send 1 specific email out to a list of people. That list of reciepients is hardcoded in the step command and I need to remove one person from that list, in all ...
Rufena asked 18/11, 2008 at 11:31
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
2
Solved
I have set up an SQL server agent job with a few steps that needs to be processed each week. One of which is a PowerShell script that will throw the following (uncaught) custom exception:
$endfile...
Uptotheminute asked 22/1, 2014 at 5:59
1
Solved
I want to start the SQL Server Agent (sql server 2008 R2 Enterprise edition), then I did:
Open SQL Server configuration manager.
SQL Server services.
Right click on sql server agent.
but...
Hausner asked 5/4, 2013 at 12:47
2
In my SQL Server agent, I did not set any notifications, then why this error is coming?
I run pakg through dtsexec it executes successfully, and also I run a simple job for inserting record it run...
Renoir asked 28/2, 2013 at 6:26
1 Next >
© 2022 - 2024 — McMap. All rights reserved.