sql-server-agent
What happens to Jobs scheduled when SQL Server Agent is stopped?
On our SQL Server theres a SQL Job which is ran every hour. On one particular hour it doesn\'t seem like the SQL Job was ran, and that was due to the SQL Ser开发者_运维知识库ver Agent being stopped du[详细]
2023-04-12 22:25 分类:问答Sql Server Agent job running longer than interval between executions
I would like to know what happens if an agent job (with recurring interval) in MS SQL server runs long enough so that it overlaps recurring execution.[详细]
2023-04-05 19:38 分类:问答SQL Server Agent Job Notify multiple operators on failure
I have a Job setup in SQL Server 2008 which sends a notification emai开发者_JS百科l to one operator when the job fails.[详细]
2023-04-04 21:53 分类:问答Stored Procedure Return Value to Fail SQL Job
I have a stored procedure开发者_运维百科 which is the first step in an SQL Job. The SP compares dates in 2 tables, if they equal then the SQL job can continue, but if they are not I need to return val[详细]
2023-04-02 15:45 分类:问答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 (e[详细]
2023-03-30 06:25 分类:问答Cannot Get DBMail to Work. Worked in the Past
SQL Server 2005 DBMail. I had all of this working, but then it just stopped.I tried starting over from scratch to no avail[详细]
2023-03-29 02:47 分类:问答SQL Server Agent Job is not running
I have a job that is supposed to run every 11 AM and 8 PM. About two weeks开发者_StackOverflow ago, it started to not respect the schedule. The \"fix\" that I found was to start the job manually and t[详细]
2023-03-22 15:30 分类:问答Best Way to Create Nightly Replication of Sql Server Database
I want to create a job that runs every night. I have a database (MyDatabase) that I want to copy/replace my staging database with (MyDatabase_Stage).[详细]
2023-03-14 03:30 分类:问答SQL Server Agent Jobs: How to execute a job step without executing the entire job
I have a SQL Server Agent Job that previously had two steps.Today, I\'ve had to integrate the third step, and soon I\'ll need to integrate a fourth.[详细]
2023-03-13 23:37 分类:问答SQL 2000 script to kill Agent job if it overuns
On a legacy SQL 2000 box that is awaiting upgrade Does anyone have a script to kill / abort a job in SQL Agent 2000 if it over runs a set duration or overlaps with another agent job.[详细]
2023-03-08 11:28 分类:问答