Saturday, February 25, 2012

DBCC DBREindex

Attempting to schedule a job to run DBCC DBREindex for all
of the tables in a database. I'm rebuilding all indexes
for various tables - job example:
BCC DBREINDEX( unq_id )
DBCC DBREINDEX( user_adr )
DBCC DBREINDEX( user_group )
DBCC DBREINDEX( user_slice_approval )
DBCC DBREINDEX( userpriv )
DBCC DBREINDEX( wg )
DBCC DBREINDEX( wg_acc )
DBCC DBREINDEX( wg_dates )
DBCC DBREINDEX( WG_FTE )
DBCC is is return the following message:
Executed as user: NT AUTHORITY\SYSTEM. ...ontact your
system administrator. [SQLSTATE 01000] (Message 2528)
DBCC execution completed. If DBCC printed error messages,
contact your system administrator. [SQLSTATE 01000]
(Message 2528) DBCC execution completed. . If DBCC
printed error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execu... The step
failed.
What am I doing wrong?Tell us what do you see in errorlog?
>--Original Message--
>Attempting to schedule a job to run DBCC DBREindex for
all
>of the tables in a database. I'm rebuilding all indexes
>for various tables - job example:
>BCC DBREINDEX( unq_id )
>DBCC DBREINDEX( user_adr )
>DBCC DBREINDEX( user_group )
>DBCC DBREINDEX( user_slice_approval )
>DBCC DBREINDEX( userpriv )
>DBCC DBREINDEX( wg )
>DBCC DBREINDEX( wg_acc )
>DBCC DBREINDEX( wg_dates )
>DBCC DBREINDEX( WG_FTE )
>DBCC is is return the following message:
>Executed as user: NT AUTHORITY\SYSTEM. ...ontact your
>system administrator. [SQLSTATE 01000] (Message 2528)
>DBCC execution completed. If DBCC printed error messages,
>contact your system administrator. [SQLSTATE 01000]
>(Message 2528) DBCC execution completed. . If DBCC
>printed error messages, contact your system
administrator.
>[SQLSTATE 01000] (Message 2528) DBCC execu... The step
>failed.
>What am I doing wrong?
>.
>|||If I look at the HISTORY for the JOB showing step details
this is what I see:
The job failed. The Job was invoked by User
LSMASTER\JBraga. The last step to run was step 4 (rebuild
index - index2.sql). The job was requested to start at
step 4 (rebuild index - index2.sql).
Executed as user: NT AUTHORITY\SYSTEM. ...ontact your
system administrator. [SQLSTATE 01000] (Message 2528)
DBCC execution completed. If DBCC printed error messages,
contact your system administrator. [SQLSTATE 01000]
(Message 2528) DBCC execution completed. If DBCC printed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed.
If DBCC printed error messages, contact your system
administrator. [SQLSTATE 01000] (Message 2528) DBCC
execution completed. If DBCC printed error messages,
contact your system administrator. [SQLSTATE 01000]
(Message 2528) DBCC execution completed. If DBCC printed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed.
If DBCC printed error messages, contact your system
administrator. [SQLSTATE 01000] (Message 2528) DBCC
execution completed. If DBCC printed error messages,
contact your system administrator. [SQLSTATE 01000]
(Message 2528) DBCC execu... The step failed.
Thank you,
Joe
>--Original Message--
>Tell us what do you see in errorlog?
>>--Original Message--
>>Attempting to schedule a job to run DBCC DBREindex for
>all
>>of the tables in a database. I'm rebuilding all
indexes
>>for various tables - job example:
>>BCC DBREINDEX( unq_id )
>>DBCC DBREINDEX( user_adr )
>>DBCC DBREINDEX( user_group )
>>DBCC DBREINDEX( user_slice_approval )
>>DBCC DBREINDEX( userpriv )
>>DBCC DBREINDEX( wg )
>>DBCC DBREINDEX( wg_acc )
>>DBCC DBREINDEX( wg_dates )
>>DBCC DBREINDEX( WG_FTE )
>>DBCC is is return the following message:
>>Executed as user: NT AUTHORITY\SYSTEM. ...ontact your
>>system administrator. [SQLSTATE 01000] (Message 2528)
>>DBCC execution completed. If DBCC printed error
messages,
>>contact your system administrator. [SQLSTATE 01000]
>>(Message 2528) DBCC execution completed. . If DBCC
>>printed error messages, contact your system
>administrator.
>>[SQLSTATE 01000] (Message 2528) DBCC execu... The step
>>failed.
>>What am I doing wrong?
>>.
>.
>|||These are all informational messages. Nothing wrong. Add WITH NO_INFOMESSAGES and I think you get
rid of them.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"jbraga" <jbraga@.lifespan.org> wrote in message news:0c2601c3af7e$e8e94e50$a501280a@.phx.gbl...
> Attempting to schedule a job to run DBCC DBREindex for all
> of the tables in a database. I'm rebuilding all indexes
> for various tables - job example:
> BCC DBREINDEX( unq_id )
> DBCC DBREINDEX( user_adr )
> DBCC DBREINDEX( user_group )
> DBCC DBREINDEX( user_slice_approval )
> DBCC DBREINDEX( userpriv )
> DBCC DBREINDEX( wg )
> DBCC DBREINDEX( wg_acc )
> DBCC DBREINDEX( wg_dates )
> DBCC DBREINDEX( WG_FTE )
> DBCC is is return the following message:
> Executed as user: NT AUTHORITY\SYSTEM. ...ontact your
> system administrator. [SQLSTATE 01000] (Message 2528)
> DBCC execution completed. If DBCC printed error messages,
> contact your system administrator. [SQLSTATE 01000]
> (Message 2528) DBCC execution completed. . If DBCC
> printed error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execu... The step
> failed.
> What am I doing wrong?
>

No comments:

Post a Comment