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)