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. Id like to make this job
successful in the job history. Is it possible to do that? How can I change i
n
the Job?
Executed as user: WCBDOM01\clusteradmin. ...tact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
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.droptable.comA jobstep should only fail if you get errors with severity > 10. I suggest y
ou start by specifying
an output file for the jobstep and post here the contents of that output fil
e. 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 droptable.com" <forum@.droptable.com> wrote in message
news:504898D6216E0@.droptable.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 pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> 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.droptable.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 252
8)
DBCC execu... The step failed. I think that the job was not failed. The
last message shouldnt 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 print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC print
ed
error messages, contact your system administrator.
[SQLSTATE 01000] (Message 2528) DBCC execu... The step failed.
Thanks,
Do.
Message posted via http://www.droptable.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 installatio
ns. 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 droptable.com" <forum@.droptable.com> wrote in message
news:50554B5DE16D0@.droptable.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 eve
ry
> 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 2
528)
> 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 pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execution completed. If DBCC pri
nted
> error messages, contact your system administrator.
> [SQLSTATE 01000] (Message 2528) DBCC execu... The step failed.
>
> Thanks,
> Do.
> --
> Message posted via http://www.droptable.com