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
1 answer

Bulk Insert command fails within the stored procedure

System Error: Cannot bulk load because the file "XYZ.txt" could not be opened. Operating system error code 1311(There are currently no logon servers available to service the logon request.) I have a stored procedure in SQL Server 2008 R2 which is…
AnkitThakkar
  • 1
  • 1
0
votes
1 answer

Is there a possibility to send a telnet command or start a bat file when I get a result in a SQL View?

I would like to send a Telnet command or start a *.bat file when I get a result in a SQL view. I am using SQL Express and so don't have the SQL Server Agent. I am trying to launch a cue in a lighting software, 30 minutes before one of our shows…
bregtV
  • 9
  • 3
0
votes
1 answer

Why SQL Server Agent is not showing even after assigning sysadmin roles to user?

I am scheduling a job in SQL Server, but the SQL Server Agent is not visible in my SQL Server Management Studio and I am using version Microsoft SQL Azure. After creating user and assigning sysadmin roles to it, the problem still lying there. I…
Kapil Sonii
  • 11
  • 3
0
votes
1 answer

WinSCP batch transfer with SQL Server Agent Job

I have a .bat file that: executes WinSCP (calls a script txt) and transfers a file through SFTP. It also archives the file that was transferred. My Problem is it works just fine when I double click the .bat file. BUT when I execute it in SQL…
Katherine Pacheco
  • 339
  • 3
  • 7
  • 24
0
votes
1 answer

SQL Server Agent Job completes without errors but doesn't work when scheduled, but works when ran manually

I have a SQL Server Agent Job that rebuilds two indexes that is scheduled to run daily. The reason I am doing this is to improve performance of a stored procedure. When the agent job is run from a schedule it does not affect the performance of the…
khaas
  • 1
0
votes
2 answers

How to kill a SQL Server job which keeps on showing an "In Progress" status?

I am using SQL Server 2014 and I have a job (let's call it JN5) scheduled to run at a specific time on a daily basis. The job runs an SSIS package and has 11 steps in it. Looking at the Job History in SSMS, the job seems to be stuck at Step 9. It is…
user3115933
  • 4,303
  • 15
  • 54
  • 94
0
votes
1 answer

Migrate SQL Server database to Azure along with database email and jobs

I am new to SQL Azure, we have taken the subscription of Azure SQL elastic pool. I have two databases in my local SQL Server and it has a stored procedure which internally is calling msdb.dbo.sp_send_dbmail and I have scheduled these stored…
junior
  • 15
  • 1
  • 5
0
votes
2 answers

Duplicate step entries in SSMS Job History Log File Viewer

I'm seeing duplicate entries by Step ID in the SSMS Job History Log File Viewer. This is only happening in one of my jobs. In the duplicates, one is marked as complete, and the other as still running. The duplicate running step has a message with a…
henhen
  • 23
  • 9
0
votes
1 answer

Python Won't Run Even Through It Is In the Path

I have a SQL Server Agent job that executes some python scripts using CmdExec. Everything is set up with a proxy account as expected. When I run the job I get: Message Executed as user: domain\proxyaccount. 'python' is not recognized as an internal…
Bob Wakefield
  • 3,739
  • 4
  • 20
  • 30
0
votes
1 answer

SQL Server Agent stops while enabling CDC for table

I am using latest sqlserver (2019) on UBUNTU 18.04. I want to enable CDC for the database and table. Enabling CDC for database is done. When i try to enable CDC for table, SQL Server Agent stops and gives the log 'SQLServerAgent is not currently…
LakshanSS
  • 126
  • 4
0
votes
1 answer

SQL Server: How to run a query every hour, and store results in a table? Replace them on update

I have this taxing query that takes 5 minutes, and I'd like to have its results stored in a table, which will be queried by a backend. Also, the table should be updated every hour and completely replace the table's content with the new data. I…
Ivan
  • 1,967
  • 4
  • 34
  • 60
0
votes
1 answer

ssis package is not being execute with job scheduled on Agent

I have developed an SSIS package and deployed it on the SQL Server which uploads flat files in the database. I scheduled it to be run every 30 seconds. the job is being executed successfully but my SSIS package is not being executed. I mean I am not…
Shahab Haidar
  • 625
  • 3
  • 11
  • 25
0
votes
1 answer

how to delete unused connections in an SSIS package deployed as an SQL Server Agent job step?

I have an SSIS package deployed to an SQL Server by Project deployment model. When I configure to use that package as a job step, I see that there are other connections that this package does not use at all (they are all project-scope connections).…
Doan Vu
  • 494
  • 7
  • 12
0
votes
1 answer

What is the meaning of "SQL server agent service account" in SQL-job?

Could anyone please help me to understand this code under SQL-Server Job steps. One of the step having this process and I am not getting its process behavior with Type - "Operating System (CmdExe)" and Run-as - "SQL Server Agent Service Account".…
Irfan
  • 665
  • 6
  • 29
0
votes
1 answer

Does creating more SQL AGENT steps for deleting records will be a performance gain or loss

I got a task to delete 9 million record from a table so iam planning to do via SQL Agent job, i have prepared script to delete as like 50000 records from one delete statement So now do i need to create single jobs with many steps or i can create…
Vishvas Krishnan
  • 1
  • 1
1 2 3
…
32 33