1

Topic: SQL Server 2000

Kind day!
Strongly do not kick for  a question, but whether it is possible in a SQL Server 2000, to create own regulated job for performance on the basis of a script, for example here the such:
ALTER DATABASE Sklad
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
DBCC CHECKDB (N'Sklad ', REPAIR_REBUILD) WITH NO_INFOMSGS
GO
Bothered to run its hands.

2

Re: SQL Server 2000

SnakePlisskin;
It is possible certainly

3

Re: SQL Server 2000

Goga-Gola;
Prompt as, I in job came there did not find, only presets can be selected.

4

Re: SQL Server 2000

SnakePlisskin wrote:

Goga-Gola;
Prompt as, I in job came there did not find, only presets can be selected.

That such "I in job came", and what such "presets"?
Create the new job, in it do "step" of type script performance, there write a script.

5

Re: SQL Server 2000

alexeyvg wrote:

Create the new job, in it do "step" of type script performance, there write a script.

Here is how that so:

6

Re: SQL Server 2000

alexeyvg;
There also it was picked where to interpose the job did not understand.

7

Re: SQL Server 2000

All found where it to do.

8

Re: SQL Server 2000

SnakePlisskin wrote:

alexeyvg;
There also it was picked where to interpose the job did not understand.

you deceived, it not job.

9

Re: SQL Server 2000

Gavrilenko Sergey Alekseevich;
And it is possible to add such script in the job:
ALTER DATABASE Sklad
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
DBCC CHECKDB (N'Sklad ', REPAIR_REBUILD) WITH NO_INFOMSGS
GO
I before it in the manual executed that and looked what messages appeared.