sql-agent-job
Find Job_State of SQL Agent Job - SQL Server
I am using below script to get the Job_state for Agent Job. It returns 1 as job_state when job is running => which is fine.[详细]
2023-03-23 16:51 分类：问答Run C# code inside a SQL Agent Job
I have a piece of code that needs to run every day at a开发者_如何学C specified time. The code right now is sitting as a part of my web application. There are 2 stored procedures to get/save data that[详细]
2023-03-19 04:44 分类：问答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 分类：问答SQL Server 2008 insert trigger not firing
I have an INSERT trigger on a table that simply executes a job. Example: CREATE TABLE test ( RunDate smalldatetime[详细]
2023-02-22 11:24 分类：问答Windows Event Log Access from SSIS package run in SQL Agent Job
I have created an SSIS package that will be deployed to client SQL installations (2005, 2008 or 2008 R2) to perform data extracts which provide a support tool for our product. The deployment process r[详细]
2023-02-21 18:13 分类：问答Get SQL Agent job status without polling?
I\'m trying to find a way to have the SQL Server \'SQL Agent\' run a particular piece of 开发者_JS百科code on job step events. I had hoped that there was a way using SMO to register a callback method[详细]
2023-01-24 18:36 分类：问答SQL Server job to check 2 databases and act based on result?
I need to check 2 tables on similar databases on different servers, if they contain the same information (or size, hash, whichever is the best way to check if they\'re the same) then one of them shoul[详细]
2023-01-10 16:31 分类：问答INSERT INTO results_table EXEC sproc from within a scheduled job
I\'m trying to setup a scheduled job that with one step that would insert the results from a sproc into a table.[详细]
2023-01-06 05:08 分类：问答SQL Server job (stored proc) trace
I need your suggestion on tracing the issue. We are running data load jobs at early morning and loading the data from Excel file into SQL Server 2005 db. When job runs on production server, many time[详细]
2022-12-30 14:09 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......