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
3 answers

scheduled execution of all TSQL scripts in a folder

I have a bunch of TSQL scripts that need to be executed on a daily basis. I know I can use Job Agent to execute them but that requires me to change the actual job. What I would like to do is create a job that simply says: execute all TSQL-scripts…
Henrov
  • 1,610
  • 1
  • 24
  • 52
0
votes
4 answers

SQL Server : scheduling programmatically

I'm trying to force SQL Server to call a needed stored procedure each hour. I've read the following articles: http://msdn.microsoft.com/en-us/library/ms190268.aspx http://msdn.microsoft.com/en-us/library/ms187320.aspx They are quite big and not…
Ruslan
  • 2,678
  • 3
  • 22
  • 25
0
votes
2 answers

SQL Server Agent Job Set Up

I'm a newbie to SQL and .Net and this question might be stupid too to ask but I still need help. I've a Database located on Server1. Now I got another Server, lets call it Server2 to work on my Development. Server1 on which my database is located…
user1345260
  • 2,151
  • 12
  • 33
  • 42
0
votes
2 answers

Accessing another SQL Server from SQL Job Agent

I have a SQL Server Agent Job on "server X." This job is simple, and uses the following query to refresh a table (on server X) by clearing it, then re-populating it with data from a view (also on server X): DELETE FROM…
CptSupermrkt
  • 6,844
  • 12
  • 56
  • 87
0
votes
0 answers

How do I run a SQL Agent job with different parameters using SMO and without having to alter the JobStep definition?

I have some SSIS packages that are stored in the SQL Server and exposed via a SQL Agent Job I have written a component that allows me to dynamically build up the correct command line for the job step containing the SSIS package which allows me to…
blue18hutthutt
  • 3,191
  • 5
  • 34
  • 57
0
votes
1 answer

SQL Server Agent Jobs Crashing

Running a Windows 2003 with SQL Server 2005 on, with around ~85-90 jobs which run once per hour (at different times), generating new sitemaps for each website hosted on the server, along with un-publishing pages. The issue which I'm having with the…
ItWontWork
  • 67
  • 1
  • 5
-1
votes
2 answers

To move SQL Server Agent Jobs from one server to another

I just need some advise or solution please. I have SQL Server SQL1 and it has more than 50 agent jobs. I have to move those jobs to a new SQL Server called SQL2. What is the best, easiest and most secure way to do so? Is there any copy and paste…
Salman81
  • 95
  • 1
  • 8
-1
votes
1 answer

Getting execution status of SQL Server Agent Job in SQL Server 2012

I am trying to get currently executing job status in SQL Server 2012. I have tried using sp_help_job procedure to get it using execution_status as argument also used run_status/status but it is not returning any value. Please help
Sagar
  • 1
-1
votes
1 answer

How to Convert a simple SELECT Statement into SQL SERVER AGENT JOB for schedule and Auto Email

How can I convert a simple select statement into SQL SERVER AGENT JOB for an auto Email to an operator. e.g. USE [DYNAMICS] select * from ACTIVITY I daily need this ACTIVITY table contents at 10:00am via Email. How I'll do it as auto Email from SQL…
adeel
  • 17
  • 8
-1
votes
1 answer

SQL Server agent deletes records at midnight

I'm kinda new to SQL so I apologize in advance if this question is not very clear. I want to create a job in SQL Server Agent that deletes a row after exactly 24 hours. My problem is the SQL Server Agent deletes the record at midnight rather than…
simon
  • 19
  • 4
-1
votes
2 answers

how to replace flat file created by a export data wizard on a schedule task with server agent

i already create a SSIS package on SSMS and scheduled in Server Agent, it create succesfully my '.csv' file but i want to overwrite the file every night when the scheduled job start again.
LuisCas
  • 45
  • 8
-1
votes
1 answer

SSIS deployed package execution using parameter at runtime

I have a package which is deployed using SQL server agent. I am executing the SQL server agent by calling a stored procedure. i have declared some variables inside the ssis package ,i want to use these variables as parameter in stored procedure. any…
junaib
  • 21
  • 2
  • 10
-1
votes
1 answer

Yearly Job Using T-Sql

Can someone help me to create Yearly Job Using T-SQL? I wanted to execute the stored proc yearly. I searched this ques in list of ques which are already asked but not able to get it.
Priyanka
  • 23
  • 1
  • 6
-1
votes
1 answer

What SQL 2000 rights are required for creating SQL Agent jobs?

It's been a long while since I looked at SQL Jobs on SQL Server 2000. On SQL 2005, if I want to allow a user to create jobs etc I add the requisite login to msdb and assign one of the roles SQLAgentUserRole, SQLAgentReaderRole or…
Kev
  • 118,037
  • 53
  • 300
  • 385
-1
votes
2 answers

SQL Server Agent Job: Invocation from a website

I am looking for tips that how can I invoke an SQL Agent job from a webpage (JavaScript)? I have not been able to do it and have not yet found something useful. Thanks in advance!
dbStudent
  • 5
  • 1
1 2 3
…
32
33