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

Cannot start SQL Agent in SQL Server 2008 Express

So my SQL Server Express version does not allow the SQL Agent service to run. I want to automate a query to execute about every 10 seconds. I suppose, given my task, it could be done every minute. Is there a way to execute an automated SQL query…
user3242661
  • 89
  • 4
  • 12
0
votes
1 answer

Show status/output of sql server agent job in web app

is there any way to show the status/output of an sql server agent job? I have an application that runs a stored procedure which actually runs an SQL Server Agent Job (See Below) but is there any way to show the status of that job that is running? If…
neeko
  • 1,930
  • 8
  • 44
  • 67
0
votes
1 answer

SQL Job: How to start with?

Can anyone help me to create an SQL job in SQL server Agent (SQL 2008) ,which will run in a purticular time interval(Ex: Daily) and select records from a table with status=1 (select name,age from student)and pass to another stored procedure which…
Shyju
  • 214,206
  • 104
  • 411
  • 497
0
votes
2 answers

Executing muliple Stored Procedures within a single SQL Server Agent Job

My SQL Server Agent job seems to execute the 1st SP cmd but not the second. Does anybody know how i get multiple commands into a single Server Agent job?
Fearghal
  • 10,569
  • 17
  • 55
  • 97
0
votes
2 answers

SQL Server Agent Job - Pass date and determine if job will run based on Schedule

I need to determine all SQL Server Agent Jobs that will run on a specific date in the future. Is it possible to determine all jobs that will run on a future date based on its current schedule. I know I can get the next_run_date value from…
user327999
  • 443
  • 1
  • 9
  • 21
0
votes
1 answer

Writing to the history of a SQL Agent Job

Having just created a SQL Agent Job I thought it would be handy to be able to write a little bit of information into the job's history, in case I wanted to check it later. I was using VBScript in this instance, and noted that I could use the Error…
Magnus Smith
  • 5,895
  • 7
  • 43
  • 64
0
votes
1 answer

Determining if a job is running

I have a job set up in SQL Server called "Retreat Update". It is a job that the SQL Server Agent runs every 45 minutes. Is there a SELECT statement or a system stored procedure that I can execute to determine if the job is currently running or if…
Icemanind
  • 47,519
  • 50
  • 171
  • 296
0
votes
2 answers

Offsetting the start time of SQL Server Agent job schedules between instances

I have an agent job set to run log backups every two hours from 2:00 AM to 11:59 PM (leaving a window for running a full or differential backup). A similar job is set up in every one of my 50 or so instances. I may be adding several hundred…
Mark Freeman
  • 1,155
  • 3
  • 24
  • 42
0
votes
2 answers

SQL Agent not kicking off an SSIS package

I have a server that has a SQL Agent job setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management Studio and .NET framework 2.0 SP1 was re-installed. The first…
Grant
  • 1
  • 1
0
votes
1 answer

Can only connect to SQL Sever 2008 Express remotely afer server restart

I am running SQL Server 2008 Express and can connect to it fine using port forwarding through my router, AND when I am on the same subnet. However when I am on a different subnet, I can only connect to it right after I restart the SQL Server Agent.…
Ashish
  • 391
  • 1
  • 3
  • 7
0
votes
0 answers

File name generated by query used in attachment

I have this query that runs in SQL Server Agent and I need to be able to pick up the correct file. Currently I have it picking up a random file that is on the D drive but I need it to pick up the file that was just created. The code for that is…
korrowan
  • 563
  • 2
  • 15
  • 37
0
votes
1 answer

unable to start sql 2005 on windows 2003 two node cluster

SQL server Agent is not starting...... In the SQLAGENT log i found this error....... 2009-10-24 22:49:36 - ? [393] Waiting for SQL Server to recover databases... 2009-10-24 22:49:40 - ! [298] SQLServer Error: 5845, Address Windowing Extensions (AWE)…
user186246
  • 1,857
  • 9
  • 29
  • 45
0
votes
2 answers

Sending Notifications from a SQL Server 2000 Job without SMTP Server on the Box

I have SQL Server 2000 installed on Windows 2003 Server. We do not have SMTP installed on the box, so when creating a notification for a failed SQL Agent job, the email is not sent. Is there a way to send out a notification without installing SMTP…
Feckmore
  • 4,322
  • 6
  • 43
  • 51
0
votes
2 answers

Powershell to return the value only for Cluster Resource

I am trying to evaluate a value from a powershell command for a SQL Agent setting on a clustered server using powershell. I am very new to Powershell but we want to set up a monitor to make sure that all of our Windows Server 2008 r2 clusters have…
BeckyH76
  • 1
0
votes
0 answers

SQL Server Agent Job - backup certain tables

I am trying to create a SQL Server Agent Job which performs the following functionality. Creates a '.bak' file containing a backup of a set tables from within a database. Zips this backup with a filename of something like "Database_20130111"…
swade1987
  • 1,663
  • 5
  • 21
  • 28
1 2 3
…
32 33