December 24, 2016 at 9:38 pm
Hi,
version - Microsoft SQL Server 2008 R2 (RTM)
initially it failed with maint plan and then I scheduled it with below:
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 90)"
again it failed with below error:-
Executed as user: NT AUTHORITY\SYSTEM. ...xecution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) .[wse_filter_set_param_value_types] [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) .[QRTZ_PAUSED_TRIGGER_GRPS] [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) .[wse_etl_tracking] [SQLSTATE 01000] (Message 0) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528)
I read on another topic that the below will help, if yes this has to be run as it is manually while the reindexing job is running or is there any other option
BEGIN TRY
DBCC...
END TRY
BEGIN CATCH
INSERT INTO TABLE
SELECT ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_LINE(), ERROR_MESSAGE()
END CATCH
December 27, 2016 at 11:24 am
I'm not really seeing any error messages in there (or I could be missing something).
If you want to get better output of possible errors, on the job step doing the reindex, edit that step, go to Advanced and in the middle of the screen there is a section for Output File.
Add a filename in a directory that the Agent has permissions for (the built in Jobs directory should work). You can then review the file and get better details of any errors.
Sue
December 27, 2016 at 11:45 pm
it show only these messages and at the end as step failed....
I ran reindexing for individual db's and found that 2 of the DB's had hyphen in their name so placed them between the brackets and they worked...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply