how do you run multiple DBCC commands in one job

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rob (anonymous_at_discussions.microsoft.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 09:59:22 -0700

Hello:

I'd like to create a job to run multiple DBCC commands in
sequence, one after the other upon successful execution of
the preceeding step (and not using the WAIT FOR TIME/DELAY
clause).

I could create a multiple step CMDEXEC job, with each step
containing its own DBCC command. However, I am afraid that
upon executing this job, SQL Server may run all these DBCC
commands at the same time without allowing each step to
complete in its entirety, as SQL Server will not verify
the completion of a the command passed within a CMDEXEC
type task.

Any suggestions on how to make the afore-mentioned process
work, will be very helpful and appreciated. Thank you in
advance.

Relevant Pages

  • Re: how do you run multiple DBCC commands in one job
    ... work (how to determine on success/on failure is the prior step didn't finish yet?). ... > I'd like to create a job to run multiple DBCC commands in ... > I could create a multiple step CMDEXEC job, ... SQL Server may run all these DBCC ...
    (microsoft.public.sqlserver.server)
  • Re: How can you tell whether a DB is corrupt?
    ... You can run the DBCC commands to check the integrity of the database. ... Vyas, MVP (SQL Server) ... is the corruption of a database always associated with its being not able to ...
    (microsoft.public.sqlserver.server)
  • db_backupoperator role on SQL Server 2000
    ... can execute certain DBCC commands, ... of "SQL Server 2000 Administrator's Pocket consultant. ... database permission errors. ... a bug/bug fix to correct this problem in SQL Server 2000. ...
    (microsoft.public.sqlserver.security)