how do you run multiple DBCC commands in one job

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

Date: Thu, 2 Sep 2004 10:10:20 -0700

One additional note:

The reason to set these steps as CMDEXEC is because I plan
to use OSQL so that the result-set generated by each DBCC
command is stored in its own output file.

Thanks.

>-----Original Message-----
>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