List SQL Server Jobs

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

  • 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