sql-job_开发者

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 Job running for 30 minutes then report successful

We have a job that runs every night and rebuild the indexes on a customer database, however after instal开发者_StackOverflow中文版ling the job, it runs successfully every night according to the histor[详细]

2023-04-07 16:17 分类：问答

How to create jobs in SQL Server Express edition

Could anyone please开发者_如何转开发 explain to me how to create jobs in SQL Server Express edition?SQL Server Express doesn\'t include SQL Server Agent, so it\'s not possible to just create SQL Agent[详细]

2023-03-31 10:49 分类：问答

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 分类：问答

Powershell Script using Invoke-SQL command,needed for SQL job, the SQL Server version of Powershell is somewhat crippled, is there a workaround?

Full Question: Have Powershell Script using Invoke SQL command, using snappins, I need them to be included in a SQL job, the SQL Server version of Powershell is somewhat crippled, does anyone know a w[详细]

2023-03-17 19:49 分类：问答

How to get the value from step1 to step2 in sql Job

I need to create a SQL JOB. Step1: Insert a Row into TaskToProcess Table and return ProcessID(PK and Identity)[详细]

2023-03-07 22:40 分类：问答

How to run a Job from a Stored Procedure in another server?

Is it possible to run 开发者_Python百科a Job from a stored procedure located in a different server? If so, how?So why not consider using[详细]

2023-02-22 19:53 分类：问答

Is there a way to set a SQL Server job scheduled to run every 30 seconds?

When I try to create a Schedule the minimum amount of time I can choose from is 1 min开发者_StackOverflow社区ute, is there a way to reduce this to seconds?This article here SQL Server Job Scheduling s[详细]

2023-02-22 06:35 分类：问答

Reading the contents of a SQL Server job in VB.NET

I am writing an application that will call a SQL Server job on all our client\'s systems. I\'m able to execute it, and wait until it\'s finished. It has an output file that\'s save location is hard c[详细]

2023-01-17 06:20 分类：问答

Select Statements in Jobs

I have inherited a few jobs and I am trying to understand why select statements would be in their steps.I would think that select statements would be开发者_C百科 pointless in an automated job that dis[详细]

2022-12-30 08:11 分类：问答