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

Configure a notification when SQL Server Agent job fails because the owner does not have server access

How can I configure an email notification when SQL Server Agent job fails because the owner does not have server access? I've created a new alert but apparently, I've not selected the appropriate selection for "Alerts will be raised based on"…
ghoh
  • 65
  • 1
  • 12
0
votes
1 answer

could not run job in sql server agent

I am trying to execute a job from SQL Server Agent however receiving the error: The login is from an untrusted domain and cannot be used with Windows authentication. The Sql server 2016 with Sql server Agent and SSIS where a credential account…
beewest
  • 4,486
  • 7
  • 36
  • 63
0
votes
1 answer

SSIS Login Error When Scheduling Package

I created a SSIS package in Visual Studio 2010 (BIDS). It's using an OLE DB Source and an OLE DB Destination. Both the source and destination use Windows authentication (a domain user) to connect and both are local to the Package. In VS the…
ptownbro
  • 1,240
  • 3
  • 26
  • 44
0
votes
0 answers

Using xcopy and del using SQL Server Agent Service Account

I am trying to use SQL Server Agent to perform some copy and delete actions on my backup files. I have created a Job as below: Problem is when this job runs, it encounters an error. I believe it is due to SQL Server Agent Service Account not having…
Windhoek
  • 1,701
  • 1
  • 15
  • 26
0
votes
0 answers

batch script to open cmd prompt with other user and enter password automatically

I'm trying to get a batch file to automatically enter the password into the "runas" program, this code is working fine but it is not supported by SQL server agent. Here's my batch file so far: @if (@CodeSection == @Batch) ‌@then ‌@echo off ‌start ""…
Undeti Upendar
  • 11
  • 2
0
votes
1 answer

How to solve this SQL Server Agent Job Error Message?

I am running SQL Server 2012 and I have set up a SQL Server Agent job which will basically run a SQL query on the database and export the output to an Excel file (with xlsx extension). When I 'parse' the query in the 'Job Properties' window to test…
user3115933
  • 4,303
  • 15
  • 54
  • 94
0
votes
1 answer

SQL Server - Migrate Agent Jobs to Azure

We're in the final phase of migrating our SQL Server on VM to Azure SQL Server. What is the most time-efficient approach to getting our existing SQL Server Agent Jobs out to Azure? I've noticed that inside of SSMS, when connected to an Azure SQL…
Stpete111
  • 3,109
  • 4
  • 34
  • 74
0
votes
0 answers

SQL Server Agent user/password login for network

I have a job that create a BCK file and transfer it over network to another machine, I need to change the machine by replacing the ip address in the sql server agent job, The issue is I'm unable to find where the credentials are set to the old…
riksof-zeeshan
  • 531
  • 9
  • 27
0
votes
1 answer

SQL Server Agent Job cannot access datafile

I have a an SSIS solution that runs fine in BIDS. However, once I try to deploy it to the server and execute through SQL Server Agent, it fails with: Cannot access datafile... Details: server: localhost that I built sysadmin: my local domain…
Pablo Boswell
  • 805
  • 3
  • 13
  • 30
0
votes
0 answers

Microsoft SQL Server 2012 SQL Server Agent

I am using Microsoft SQL Server 2012 - 11.0.2100.60 Express Edition (64-bit) RTM Product Level. I am not able to see SQL Server Agent After installing the setup. I tried through Services as well, but it gives an error. Does Express edition not have…
Priyanka
  • 23
  • 1
  • 6
0
votes
0 answers

SQL Server Agent TSQL Job Error: Exporting query results into CSV and emailing CSV

The following TSQL code fails with this error: "Executed as user: . Failed to initialize sqlcmd library with error number -2147467259. [SQLSTATE 42000] (Error 22050). The step failed." I'm unsure why, any help would be greatly appreciated! I tested…
ykadaru
  • 1,108
  • 2
  • 16
  • 32
0
votes
0 answers

Running two sql server jobs into a single job not working

we have a sql server agent job which is running two sql servant jobs.The job is designed in the way that the second job will wait till the first job completed. But sometimes the wait is not working and it causes both jobs ends up running at same…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
0
votes
0 answers

The request failed or service did not respond in a timely fashion 2014 SQL server // SQL server agent cannot start

"The request failed or service did not respond in a timely fashion." TCP/IP I have some problems, i have downloaded microsoft SQL server 2012 and it was working perfectly fine before, using my local server (my own computer). but there's this day, it…
user7359683
0
votes
1 answer

SQL Server 2012 job scheduling

I have a situation where I have 1 package (Package A) that take about 3 min to complete and another package (Package B) that takes about 4 min to complete. I need package A to run every 5 min via a job and package B to run every 15 min. However…
Mutai
  • 125
  • 1
  • 1
  • 9
0
votes
1 answer

search step that ran at exact time?

I have an instance with almost 1000 jobs. We have a deletion occurring in one of our tables that shouldn’t be happening. (I have a trigger in-place). AFTER DELETE AS INSERT INTO myTableHistory (DeletedDate, DeletedBy) SELECT…
Chicago1988
  • 970
  • 3
  • 14
  • 35
1 2 3
…
32 33