Re: how do you run multiple DBCC commands in one job
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 09/02/04
- Next message: Alex Cheng: "Re: Any problem for using a single data file?"
- Previous message: dmatheson: "Re: TempDB Concurency"
- In reply to: Rob: "how do you run multiple DBCC commands in one job"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 12:21:51 -0500
Do it the easy way. Create multiple job steps (one step per DBCC command).
You will be able to output the results of each job step to a file. Look on
the advanced tab for each job step -- creating the file should be easy
enough.
-- Keith "Rob" <anonymous@discussions.microsoft.com> wrote in message news:009101c4910e$31fadbb0$a401280a@phx.gbl... > 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.
- Next message: Alex Cheng: "Re: Any problem for using a single data file?"
- Previous message: dmatheson: "Re: TempDB Concurency"
- In reply to: Rob: "how do you run multiple DBCC commands in one job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
