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

SQL Server 2008 Agent jobs. Two procedures and a view

I'm using two stored procedures a view to create report. Every 3 months, I have to update these two stored procedures and view automatically. First, I should update stored procedure 1 Then, I need to update view (it takes data from stored procedure…
Amelia K
  • 61
  • 1
  • 6
0
votes
1 answer

sp_send_dbmail fails in SQL Server Agent Job

Could someone explain and resolve the following issue. Thanks. I encountered this query issue when I run it in SQL Server 2012 on Windows Server 2012. The query (@query) runs very well when it stands alone, but it shows no result when placed into a…
HoangDo
  • 1
0
votes
3 answers

SQL Server Agent 2005 job runs but no output

Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though). The job steps are: 1) Delete all rows from table; 2) Use For each loop…
alimack
  • 611
  • 2
  • 9
  • 20
0
votes
0 answers

How to edit SQL Server Agent job without being owner of the job or 'sa'?

I have a SQL Agent job owned by 'sa'. I created a 'SQL Login' and granted permission to 'msdb' database with the following Database role membership: SQLAgentOperatorRole SQLAgentReaderRole SQLAgentUserRole The user can execute and view the job. But,…
jmrio
  • 133
  • 1
  • 2
  • 8
0
votes
1 answer

SQL Server - send email task on job failure

we have a job that runs several times a day making incremental backups. We have added a step 'Send email on Job failure' that uses T-SQL to send an email to the admins team if the first step (Incremental backup) has failed. Unfortunately we must…
Our Man in Bananas
  • 5,809
  • 21
  • 91
  • 148
0
votes
3 answers

SSIS 2005 running in SQL Server Agent on local PC connecting to database on remote server produces error

I'm trying to run an SSIS 2005 package from a SQL Server Agent job on my local PC. This package is attempting to connect to a SQL Server 2005 database on a remote server, but it gets the error message, Login failed for user 'NT AUTHORITY\ANONYMOUS…
user317178
  • 1
  • 1
0
votes
1 answer

What firewall rules are necessary for SQL Server Multi-Server Administration

What firewall rules are necessary for SQL Server Multi-Server Administration? This is for an environment where database servers are in different 'zones', with all traffic blocked by default. We've opened up SQL Server traffic (i.e. 1433/TCP and…
Real World IS
  • 97
  • 2
  • 9
0
votes
1 answer

SQL Server Agent alternative to VBScript

I have various databases I want to read from, do some stuff with the data (maths, combine strings etc) and write it to another database. All that repeating every day at a certain time. Currently this is done via an ActiveX-Script (VBScript) in the…
Biberwerke
  • 133
  • 3
  • 10
0
votes
1 answer

SQL Job: CmdExec with Multiple Arguments

Is it possible to specify two arguments to CmdExec in SQL JOb Step? I have MyApp.exe Para1 Para2 but it only recognize para1.
Vilasack Phothisan
  • 1
  • 1
  • 4
0
votes
1 answer

DTSX package runs correctly from SSIS store but not SQL Server Agent

I am relatively new to SSIS packages Package is a File system task to rename and move a file. Package runs correctly from SSIS store but whe I run it as asql server agent job it doesnt move or rename file but shows successful. What am I doing wrong
Joe Munch
  • 3
  • 2
0
votes
0 answers

SQL Server Jobs Running Every 2 minutes...Bad Practice?

We have two servers, one is very slow and geographically far away. Setting up distributed queries is a headache because it does not always work (sometimes we receive a The semaphore timeout period has expired) and if the query works it can be slow.…
jmzagorski
  • 1,135
  • 18
  • 42
0
votes
1 answer

Can SQL Server send a notification via email?

Does SQL Server has the ability to send a notification to a specific email address when some events have been triggered? Context: I have a table contains a lot records about many partners. I wish if any partner's records have been changed, the SQL…
CodTango
  • 345
  • 1
  • 3
  • 15
0
votes
1 answer

How can I check if a SQL Server database engine is updating?

Context: I have a SQL Server database engine called DB4, and it's updating all its databases from another database engine called DB5 through the SQL Server agent every 5 hours. I don't have access to DB5, but I have been told DB5 is also updating…
CodTango
  • 345
  • 1
  • 3
  • 15
0
votes
1 answer

Job not executing

Hi i have a set of SSIS packages which i have deployed in my local db i.e. in msdb. I have created a job to execute the package but when i run the job i am getting the following error. Message The job failed. Unable to determine if the owner…
user3149140
  • 3
  • 1
0
votes
1 answer

Stored Procedure to Excel - Scheduled and Emailed

As I understand it, one can create an SSIS package that will run on a schedule with SQL Server Agent, and email the results in an Excel format. YAY IDEAL! I've looked into how to do this, and everything seems to fall just short of EXACTLY HOW. What…
Gant Laborde
  • 6,484
  • 1
  • 21
  • 30
1 2 3
…
32 33