ok - understood, let me change the question slightly

assuming the configuration was set before the reboot -why would this suddenly prevent SQL jobs from scheduling, opening etc..

The stored procedure looks like this:

PRINT convert(varchar(8), getdate(), 114) + ' - Start'

DBCC DBREINDEX (table1)

DBCC DBREINDEX (table2)

DBCC DBREINDEX (table3)

PRINT convert(varchar(8), getdate(), 114) + ' - Tables 1-3 Completed'

DBCC DBREINDEX (table4)

DBCC...

Yes - that works no problem

All sorted now

Thanks,

Craig

Thanks for the response - I couldn't find a way to do it but I'd hoped it would have been possible. Unfortunatley the query is generated from a 3rd party...