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

    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
    Posts
    2

    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
  •