Job failed in Job scheduler

I got the following error messages from a job history. It says that the job
failed. Actually these messages are warning. I?d like to make this job
successful in the job history. Is it possible to do that? How can I change in
the Job?
Executed as user: WCBDOM01\clusteradmin. ...tact 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.
I ran the following job through scheduler.
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 )
Thanks in advance,
Do.
--
Message posted via http://www.sqlmonster.comA jobstep should only fail if you get errors with severity > 10. I suggest you start by specifying
an output file for the jobstep and post here the contents of that output file. That should give a
more complete picture of the messages returned.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:504898D6216E0@.SQLMonster.com...
>I got the following error messages from a job history. It says that the job
> failed. Actually these messages are warning. I'd like to make this job
> successful in the job history. Is it possible to do that? How can I change in
> the Job?
>
> Executed as user: WCBDOM01\clusteradmin. ...tact 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.
>
> I ran the following job through scheduler.
> 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 )
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com|||I already posted the detailed message in the first note (I posted it here
again).
I know the cause. The messages are warning, but it keeps sending alert every
day. Also, X mark is shown beside the name in the Job in EM.
The last sentence of the message says that [SQLSTATE 01000] (Message 2528)
DBCC execu... The step failed. I think that the job was not failed. The
last message shouldn?t be displayed.
Is there a way to avoid the ?The step failed? message from occurring?
I
The following is the detailed messages.
Executed as user: WCBDOM01\clusteradmin. ...tact 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.
Thanks,
Do.
--
Message posted via http://www.sqlmonster.com|||So the messages are from the job step output file, not from the job history? Then I'm out of ideas.
Agent haven't failed jobs with only informational messages in my installations. You might want to
open a case with MS Support on this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:50554B5DE16D0@.SQLMonster.com...
>I already posted the detailed message in the first note (I posted it here
> again).
> I know the cause. The messages are warning, but it keeps sending alert every
> day. Also, X mark is shown beside the name in the Job in EM.
> The last sentence of the message says that [SQLSTATE 01000] (Message 2528)
> DBCC execu... The step failed. I think that the job was not failed. The
> last message shouldn't be displayed.
> Is there a way to avoid the "The step failed" message from occurring?
> I
> The following is the detailed messages.
> Executed as user: WCBDOM01\clusteradmin. ...tact 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.
>
> Thanks,
> Do.
> --
> Message posted via http://www.sqlmonster.com