List SQL Server Jobs

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by neder » List SQL Server Jobs

List SQL Server Jobs

Rate Topic

Display Mode

Topic Options

Author

Message

neder

Posted Thursday, November 01, 2007 1:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 09, 2011 2:29 PM
Points: 120, Visits: 59

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

Post #417411

loi.nguyen2000

Posted Wednesday, August 17, 2011 12:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 4:41 PM
Points: 8, Visits: 79

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?

Post #1161361

« Prev Topic | Next Topic »

Permissions