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
2
votes
4 answers

Analysis Services Processing Task Fails When Run By SQL Server Agent

I have an SSIS package which contains an Analysis Services Processing Task. This package is kicked off by a SQL Server Job in SQL Server 2008 R2. If I run this job myself or process the cube manually everything is fine. However if I schedule the job…
Leigh
  • 336
  • 5
  • 19
2
votes
1 answer

SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider OraOLEDB.Oracle.1 is not registered

I have two servers: Server A - This is where my SSIS packages live in a file directory Server B - This is where my SQL Server 2008 database and SQL Server Agent Job lives. On Server B, I have created a SQL Server Agent Job that has one step: It…
Jon Jaussi
  • 1,298
  • 3
  • 18
  • 36
2
votes
1 answer

What happens to Jobs scheduled when SQL Server Agent is stopped?

On our SQL Server theres a SQL Job which is ran every hour. On one particular hour it doesn't seem like the SQL Job was ran, and that was due to the SQL Server Agent being stopped during a backup. If SQL Server Agent has been stopped, are the jobs…
Curtis
  • 101,612
  • 66
  • 270
  • 352
2
votes
2 answers

Stored Procedure Return Value to Fail SQL Job

I have a stored procedure which is the first step in an SQL Job. The SP compares dates in 2 tables, if they equal then the SQL job can continue, but if they are not I need to return value from the SP that causes the SQL Job to trigger it's on…
Adrian S
  • 1,007
  • 4
  • 12
  • 26
2
votes
1 answer

SSIS job is not able to access the Azure File share path

I am testing the azure file share with SSIS hosted on Azure VM. However, I am facing an issue while running the job. Package execution through Visual Studio is successful Package execution through catalog also is successful Package execution…
Junior
  • 21
  • 1
2
votes
1 answer

Cannot Get DBMail to Work. Worked in the Past

SQL Server 2005 DBMail. I had all of this working, but then it just stopped. I tried starting over from scratch to no avail The surface area configuration tool has been used to make sure the procs in msdb are active. I've tried stopping and…
jtb
  • 347
  • 1
  • 2
  • 7
2
votes
2 answers

How to run SQL Server Agent Powershell script with output and exit code

I'm trying to run a PowerShell script as a SQL Server 2016 Agent job. As my Powershell script runs, I'm generating several lines of output using "Write-Output". I'd like to save this output to the job history, and I only want the job to continue to…
Duane Theriot
  • 2,135
  • 1
  • 13
  • 16
2
votes
2 answers

The installation of SQL server agent is disabled on full edition of sql server 2008R2

Practically overnight, the SQL Server agent that had been working for over a year failed on a server running SQL Server 2008 R2. When attempting to restart it, it fails immediately with the message "This installation of SQL Server Agent is…
ziga cibic
  • 23
  • 1
  • 5
2
votes
1 answer

Who disabled a job in SQL Server Agent

I have a job in SQL server Agent. Now I see that this job is disabled. Multiple people can log in to server and can modify jobs (department policy). I want to find out which user disabled this job.
user2352554
  • 521
  • 4
  • 17
2
votes
2 answers

SSIS Package is not executing from SQL Agent Job

I am trying to create a scheduled job, which should be executed daily at 23:15 o'clock. If I execute my package from Visual Studio it is working fine and it fills my Excel-files. But this is only working, when I do it manually. If I execute my…
malue
  • 59
  • 2
  • 10
2
votes
1 answer

SQL Agent: Set a Max Execution Time

Afternoon. I have several SQL Agent jobs running on an MS 2K8 BI server, some of them on a daily basis, others hourly, and one every two minutes (a heartbeat monitor for another process). There is also an app which imports data every few minutes,…
user565869
2
votes
0 answers

how to backup with a unique file name

i am trying to take a backup by creating a job in sql server agent using stored procedure. i am able to take the backup but each time it overwrites my previous backup file. i want my backup should create a different file with unique file name using…
simer
  • 47
  • 4
2
votes
1 answer

ADServiceAccount as Proxy Account for SQL Server Agent To schedule SSIS packages from SSISDB

I want to use a Managed ADServiceAccount created using the following powershell command as a proxy account to schedule and execute ssis packages : New-ADServiceAccount -Name seraccname -Enable $true -DNSHostName domainname.local Set-ADServiceAccount…
Noobie
  • 21
  • 3
2
votes
2 answers

SQL Server Agent - Unique ID for Each Job Execution

I have this query that provides a lot of useful info for my scheduled jobs but there is one thing I am still missing. I am trying to locate a unique ID for every job execution, not the instance or schedule ID. Does this exist, and of so how would I…
CRN BI
  • 21
  • 5
2
votes
0 answers

Creating Credential to run SQL Server Agent Job on Server NOT on a domain

I have set up a SQL Server on an EC2 instance that is NOT on a domain. I need the SQL Server Agent to run SSIS scripts, do back ups, send DB Mail, . I have set up a sql server user with read / write db permissions, and tried to follow the…
Mike de H
  • 599
  • 2
  • 6
  • 13
1 2 3
…
32 33