Post reply

List SQL Server Jobs

  • November 1, 2007 at 1:48 am

    #376618

    Comments posted to this topic are about the item List SQL Server Jobs

  • August 17, 2011 at 12:17 pm

    #1369784

    I ran this script on SQL 2005. I kept getting the error on 'while 1=1' with the message "The query uses non-ANSI outer join operators ("*=" or "=*")". It suggested me to run sp_dbcmptlevel MSDB,80. After executing this sp, I execute the script. I got errors on all sysjobschedule table.

    Can you repost the script that will run on SQL 2005 without resetting the default configurations?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply