sql-server-agent
How to accurately detect if a SQL Server job is running and deal with the job already running?
I\'m currently using code like this to detect if a SQL server job is running. (this is SQL Server 2005, all SP\'s)[详细]
2023-03-02 13:44 分类：问答The proper way to disable/enable SQLServer Agent Jobs
I have a number of SQLServer agent scheduled jobs, one of them performs a full database backup. I want to disable some other jobs when backup begins and re-enable them once backup is done. What is the[详细]
2023-02-19 01:15 分类：问答How to expose more information about the failure of a stored proc in SQL agent
I have a SQL agent job setup and in that job there is a step to execute a stored proc. If that stored proc fails then the SQL agent job will display an error message but there is no other information.[详细]
2023-02-16 07:08 分类：问答What does the word "pager" mean in SQL Server Agent context?
I want to kn开发者_StackOverflow社区ow the meaning of pager in SQL Server Agent context. Anybody can explain it please?[详细]
2023-02-02 14:24 分类：问答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 f开发者_StackOverflow中文版ailed with the below error message.What is this exception about? What c[详细]
2023-01-29 08:17 分类：问答how to start a sql server agent job from java code
I have few SQL Server Agent Jobs running in my project. The jobs run perfectly as scheduled, no issues.[详细]
2023-01-21 03:34 分类：问答SQL Server (SQLEXPRESS) and SQL Server Agent (SQLEXPRESS)
I came across these two services separately running in Services.msc - SQL Server (SQLEXPRESS) - started+Automatic[详细]
2023-01-20 08:13 分类：问答Notify Operator if ANY step in job fails
Can I (How do I) configure Sql Server 2008 to notify an operator if any step in the Job fails? I have a Sql Server job with several steps to update data from multiple different sources, followed by o[详细]
2023-01-19 03:42 分类：问答SQL Server Agent stop, start, pause, restart buttons are all disabled
Can anyone know why all the buttons are disabled ? I am trying to create开发者_C百科 a Job on SQL Server 2008 R2 Express.[详细]
2023-01-17 00:29 分类：问答SQL Agent Command Line Not Saved
I have a SSIS package I am trying to schedule. I create a new job under SQL Server Agent. On the Command line tab of the jobstep, I choose \"Edit the command-line manually\".[详细]
2023-01-03 15:33 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......