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

SQL server 2005 agent not working

Sql server 2005 service pack 2 version: 9.00.3042.00 All maintenance plans fail with the same error. The details of the error are:- Execute Maintenance Plan Execute maintenance plan. test7 (Error) Messages Execution failed. See the maintenance…
flaggers
  • 13
  • 3
1
vote
1 answer

Accessing a share from a sql server job

I'm trying to run a SQL job (sql server 2008) every day that needs to read a file stored on another server. I have set up a share and I can access it using my user through windows explorer. Then I set up the sql job to "run as" that same user, but…
Marie
  • 112
  • 2
  • 12
1
vote
4 answers

How to edit the SQL Agent Job from within SSMS 2005?

I am trying to edit or view the SQL Agent's job (I am the owner of this job) from SSMS 2005 and I can't find out how to do this. When I am double-clicking a job or entering job's properties I get empty "New Job" window. Is there some way to correct…
mipi
  • 273
  • 4
  • 14
1
vote
1 answer

SQL Server Management Studio will not redirect output from command line

I am using SQL Server Agent to run a few scripts regularly of type CmdExec with the following format: "Absolute path to RScript.exe" "Absolute path to script.R" > "Absolute path to log folder\logfilename.txt" This line will work when used manually…
Birk
  • 59
  • 5
1
vote
1 answer

SQL Server Agent in Azure SQL cloud Database

I have create a job in my SQL Sever Agent in my on prem database. Now I want to move my database to Azure Cloud database but how I can schedule my job at Azure cloud database? Can I use my management Studio connect to the cloud database and create…
Bubble Bub
  • 651
  • 4
  • 12
  • 32
1
vote
1 answer

deadlock on concurrent processes separated by transaction isolation level

We have a workorder table. A server agent jobs grabs 100 entries from this table in a cursor and do some work. To parallelize this there are 10 server agent jobs, which call the following procedure (each with its own @process_id): CREATE PROCEDURE…
rabudde
  • 7,498
  • 6
  • 53
  • 91
1
vote
1 answer

Run a SQL Server Agent Job from Python

I am trying to trigger a SQL Server Agent Job (takes a backup of the db and places into a directory) from python. Unfortunately, I haven't found anything in regards to python triggering a SQL Server Agent Job (only the other way around, SQL Server…
Elliot Gitter
  • 60
  • 8
1
vote
1 answer

Move a SQL Server Agent job from dev server to test server using a SQL script

I created a SQL Server job on the dev server with name Job_Test. Now my team wants me to create a new job on dev with name Job_Dev and move Job_Test to the test server. Is there a way to just transfer Job_Test to the test server without having to…
veda
  • 33
  • 3
1
vote
0 answers

Is there a way to use an SQL Server Agent to write a .txt report file after multiple steps?

Goodmorning fellow programmers, I'm working on a company's server, trying to implement daily check functions on our databases via SQL server agents. These functions are scheduled to run every morning, do their things (mostly check on conflicts…
Redd0beard0
  • 13
  • 4
1
vote
1 answer

Deployed SSIS package will not read a file

I have an SSIS package that is supposed to read a folder and if the folder contains any text files, it will read them and store the data into a database. The package works flawlessly from the file system, however when I deployed it it fails. The…
Coda759
  • 107
  • 14
1
vote
1 answer

Run query for each element in array or list

I'm trying to monitor all connections that hit our databases. In order to do so I created this query: SELECT @@ServerName AS [ServerName] ,NAME AS DatabaseName ,COUNT(STATUS) AS [NumberOfConnections] …
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
2 answers

SQL 2000 equivalent of SQLAgentReaderRole

I have quite a few developers asking me if certain SQL jobs ran, and I would like to give them access to check it on their own without giving them sysadmin rights. I know that in SQL 2005, you can grant them the SQLAgentReaderRole, but I am looking…
Shane schnell
1
vote
1 answer

SQL Server Agent Job monitoring and notification

I want to create a stored procedure/ Job that will monitor all the SQL server Agent job. When any of the SQL Server Agent's jobs fail it will send and email with the job name to the admin. What is the best way to create such a job that will monitor…
Prateek
  • 231
  • 3
  • 6
  • 12
1
vote
1 answer

Using SQL Server Agent in DataGrip

I've been testing DataGrip as a SQL IDE recently and I really like it. Particularly I decided to test it because of the multiple database type support. One issue that I am having, and that is forcing me to keep SSMS open, is the SQL Server Agent. …
JasonWH
  • 179
  • 2
  • 17
1
vote
1 answer

Can I run SQL Server Job through Linked Server?

I have two SQL Server machines: SqlServer-1 SqlServer-2 I have a job created on SqlServer-1 named RunExeFile. SqlServer-2 can access SqlServer-1 through a linked server. Can I start the job RunExeFile from a stored procedure on SqlServer-2 ?
Ali
  • 91
  • 1
  • 8
1 2 3
…
32 33