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

Get SQL Server Agent jobs configured with Email Notification

I have lot of jobs in my SQL server agent. I want to know which all the jobs are configured with email notification. I can do individually by editing and checking for the job steps. Any query/procedure to give the job names that have email…
Manoj Nayak
  • 2,449
  • 9
  • 31
  • 53
1
vote
4 answers

What does the word "pager" mean in SQL Server Agent context?

I want to know the meaning of pager in SQL Server Agent context. Anybody can explain it please? Thanks
Just a learner
  • 26,690
  • 50
  • 155
  • 234
1
vote
0 answers

Maintenance Plan read Server Agent log

I am new in maintenance plan and server agent. I have created two server agent job named as ABC and with type T-SQL (SELECT * FROM ABCDEFG), and server agent job named as DEF and with type T-SQL (SELECT * FROM ABC). When I execute ABC job in server…
Arzozeus
  • 103
  • 2
  • 11
1
vote
1 answer

Disable all SQL Agent Jobs in a particular category

I have the following query that generates the commands necessary for me to disable all the SQL Agent jobs particular to a category. Select 'Exec MSDB.dbo.sp_update_job @job_name = N''' + SJ.Name + ''', @Enabled = 0' FROM msdb..sysjobs SJ inner…
Philip
  • 2,460
  • 4
  • 27
  • 52
1
vote
1 answer

How To Stop A SSIS Package Step In SQL Server Agent Job

I have a SQL Server Agent job that runs on daily basis and the first step in the job is to execute a SSIS package. For the past a few days the step 1 is being running endlessly. Is there anyway that I can shut down the running step?
PURWU
  • 397
  • 1
  • 8
  • 22
1
vote
1 answer

SSIS scheduled job not found under SQL Server Agent --> Jobs

I have an SSIS package in Microsoft SQL Server 2012 that is running on a schedule. When i choose Integration Services Catalogs --> XXXDB --> Project --> Packages --> Right Click on the .dtsx file --> Reports --> Standard Reports --> All executions…
Shruti
  • 107
  • 2
  • 14
1
vote
2 answers

Trouble calling stored procedure with parameters

I am trying to update SQL Server Agent schedules using msdb.dbo.sp_update_schedule, but when I try to call the stored procedure from code I get exceptions. System.Data.OleDb.OleDbException: Error converting data type int to tinyint. at…
Tester101
  • 8,042
  • 13
  • 55
  • 78
1
vote
3 answers

Proxy account has failed while executing SSIS through Agent

Recently when I created a SQL Server Agent(2008) job to execute a SSIS package with proxy account, it failed with the below error message. What is this exception about? What causes it and how do I resolve it? Error Message Executed as user: blaw.…
rmdussa
  • 1,549
  • 10
  • 27
  • 50
1
vote
0 answers

Set SQL Server Agent job to run hourly at specific time

I have a job I want to create that will run once an hour. However, I want this job to run at HH:58, not HH:00. There doesn't seem to be a way to specify this in the schedule details. Am I missing something or can this not be specified for…
Tom
  • 4,467
  • 17
  • 59
  • 91
1
vote
1 answer

SQL Server Agent job dependency (not step)

We have 2 Jobs created in SQL Server Agent. PreLoad DWHLoad Job step list in both Jobs have various steps. DWHLoad needs to be run after successful completion of PreLoad Job. As of now, I've scheduled PreLoad to run at 1:00AM and it finishes at…
Ash
  • 1,180
  • 3
  • 22
  • 36
1
vote
2 answers

SQL Server Agent Job Error: At least one of the DTS, SQL, ISServer or File options must be specified

I'm trying to run an SSIS job daily using the SQL Server Agent. In my job step I have: Type - Operating System (CmdExec) Run as: Sql Server Agent Service Account Command: "C:\Program Files (x86)\Microsoft SQL…
Joey
  • 31
  • 4
1
vote
2 answers

SQL Server Agent permissions versus user permissions

I am setup as an admin on our SQL Server 2012 and I have created a job that runs a procedure that selects records from 2 joined tables. This all works fine when I am logged into SSMS and manually launch the job. The problem is when I try to schedule…
C-COOP
  • 123
  • 1
  • 3
  • 12
1
vote
2 answers

information_schema.columns returns 0 rows to my SQL Server Agent

I'm just stuck in with this problem and unfortunately I couldn't find anything to it not even when googling around... I'm running the following query on a SQL Server 2005 database: select @TableCount = count(distinct table_name) from…
Gustin
  • 918
  • 7
  • 12
1
vote
1 answer

SQL Server Agent (SQLEXPRESS) automatically stop

I'm encountering a problem on Microsoft SQL Server. SQL Server Agent is not running, when I tried to start it and refresh the services.msc the SQL Server Agent is not running anymore. When I see the logs on event viewer. There are no errors but a…
Kevin Karl Leaño
  • 1,630
  • 3
  • 15
  • 20
1
vote
1 answer

SQL Server Agent Doesn't Allow Me To Run Jobs

There are a number of SQL Server Agent jobs set up that run on schedules and they run OK. When I use Management Studio, right click any job and select "Start at Step...", a dialog pops up and says "starting..." then success, but the "executing..."…
Michael
  • 40
  • 3
1 2 3
…
32 33