var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
exec msdb..sp_help_jobhistory @mode = 'SUMMARY'
Server: Msg 14266, Level 16, State 1, Procedure sp_help_jobhistory, Line 79
The specified '@mode' is invalid (valid values are: SUMMARY, FULL, SEM).
When I double-click to open a job in EM, I get the same error message, but with a different content:
Error 14266: The specified '@class' is invalid (valid values are: JOB, ALERT, OPERATOR).
Well folks, we found out that the problem was caused by the UPPER and LOWER string functions. They were not working and produced a null result. W changed all the relevant msdb stored procedures and since we run case insensitive, its working now.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors