Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Exclamation Unanswered: SQL Agent not working correctly, returns 14266

    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).

    Any suggestions.
    Thanks Lennart

  2. #2
    Join Date
    Jun 2004

    UPPER and LOWER string functions not working

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts