I\'m currently using code like this to detect if a SQL server job is running. (this is SQL Server 2005, all SP\'s)
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
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.
I want to kn开发者_StackOverflow社区ow the meaning of pager in SQL Server Agent context. Anybody can explain it please?
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
I have few SQL Server Agent Jobs running in my project. The jobs run perfectly as scheduled, no issues.
I came across these two services separately running in Services.msc - SQL Server (SQLEXPRESS) - started+Automatic
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
Can anyone know why all the buttons are disabled ? I am trying to create开发者_C百科 a Job on SQL Server 2008 R2 Express.
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\".