Home Forums SQL Server 2005 Administering sql job RE: sql job

  • October 29, 2012 at 7:10 am

    #1553713

    Check that the user configured in Idera has the correct permissions to view SQL Server Agent jobs, best achieved by assigning that user to a fixed DB role as per the MSDB database fixed roles for SQL Agent (see URL: http://msdn.microsoft.com/en-us/library/ms188283.aspx )

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.