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

Schedule/Edit Maintenance Tasks for SQL Express (No Maintenance Plan Wizard)

I am using SQL Server 11.0.6251 Express (SQL Server 2012 Express). I have some software that logs data to the database continuously. However, there are some maintenance tasks that are performed on the database every so often. Whenever this happens,…
Fili G
  • 1
0
votes
1 answer

Executing windows shell command involving a VB script via SQL Server Job Agent or Windows Scheduler

I am having a problem with execution of a shell command involving a VB script via a SQL Server Agent and also Windows Scheduler (I am trying to get at least one of these options to work). The command runs and completes fine when executed manually…
bda
  • 372
  • 1
  • 7
  • 22
0
votes
1 answer

Linked server objects security model

I need to lock down access to a linked server object in MSSQL server. I am building views on a host database, from which, I query to populate a staging table on my warehouse server. I am using Data Tools/SSIS to extract the view data. To simplify…
henhen
  • 23
  • 9
0
votes
0 answers

SQL Server Agent is stuck in Starting status

Our SQL Agent server stopped working suddenly. We checked services and found that it got stuck in "Starting" status. We tried to restart by right click option but all start, stop and restart options are disabled (displaying grey). We checked Sql…
Rama Shankar
  • 103
  • 2
  • 10
0
votes
2 answers

SSRS Subscription in SQL Agent Failing - Unable to determine if the owner of job has server access

I have done much searching on this without a solid solution. I just set up a new SSRS instance on the same server as my SQL 2016 instance. Everything is running fine report wise, etc. The problem is that when a report is scheduled, it creates a Sql…
Jordan Ryder
  • 2,336
  • 1
  • 24
  • 29
0
votes
1 answer

Running bat file from SQL server job

I have a bat file. If I run it, it does everything it's supposed to do. Now I want to run that bat file from SQL server job. RunProg.bat consists of this: "C:\Program Files\R\R-3.3.2\bin\RScript.exe" "C:\Program…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
0
votes
0 answers

SQL Server Agent fails some SSIS jobs

I've been tasked with deploying a handful of SSIS packages on Microsoft SQL Server 2012 Enterprise 64-bit (11.0.6020.0) running on Windows Server 2012 R2. The packages run perfectly when run from SQL Management Studio by right-clicking the package…
Niels B.
  • 5,912
  • 3
  • 24
  • 44
0
votes
1 answer

How to configure Azure File Storage to access from Windows Service

We are developing and SSIS service to import some data in Excel and CSV files in Azure. For uploading the files we have chosen Azure File Storage and we are running the SSIS packages on a VM. For picking up the files from file storage, we have…
Hemant
  • 411
  • 4
  • 15
0
votes
1 answer

Merge from 2 different servers: SQL Server Agent Job - Authentication Error

I have a SQL statement that merges 2 databases together, from 2 different servers (SQL Server 2012 for both). The two servers are linked, so when executing the statement in a query window from Management Studio with the SA account it works…
Val.B
  • 93
  • 1
  • 2
  • 13
0
votes
1 answer

Schedule a SQL Job to send an email alerts if Column is NULL in SQL 2016?

How to schedule a job in SQL server, when SQL Job to send an email alert if Column 'Volume' in Table 'table1' is NULL?
CR241
  • 2,293
  • 1
  • 12
  • 30
0
votes
2 answers

Copy records using stored procedure from SQL Server to SQL Server ( 2005)

I have one simple stored procedure to select, format and copy records from TimeCard database to our ERP database. Both are SQL Servers. It is running on SQL Server Agent as a scheduled job. The code look like this INSERT INTO…
Rauf
  • 12,326
  • 20
  • 77
  • 126
0
votes
2 answers

SQL agent job failing at a step despite error handling

My SQL Server instance has an agent job called Grand Master that runs to a schedule every minute, 24/7. I have created another job that needs to be run manually from time to time. One of the first things it needs to do is disable and stop the Grand…
Cam
  • 2,026
  • 3
  • 25
  • 42
0
votes
1 answer

Getting errors while trying to get SQL Server Agent to work

I am trying to get SQL Server Agent on an instance of 2014 and an instance of 2016 to run. Currently both of them start up but then immediately stop with the message: The SQL Server Agent (VERSION16) service on Local Computer started and then…
dducharme
  • 3
  • 1
  • 1
  • 3
0
votes
0 answers

What is the alternative solutions for SQL server agent on shared hosting

I host my application and SQL database on shared hosting and I want to run SQL jobs but SQL server agent is not available on shared hosting . What is the way of accomplishing this ? Or recommendations for shared hosting company allow SQL server…
kerolos malak
  • 57
  • 1
  • 3
  • 6
0
votes
2 answers

MS SQL job is running well but it will take double time as per given time

I was created a job in MS-SQL Server Agent which running schedule is every 10 minutes time. But it run after 20 minutes continuously. What I did wrong in setting? enter image description here
Sagar
  • 15
  • 6
1 2 3
…
32 33