Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

List SQL Server Jobs Expand / Collapse
Author
Message
Posted Thursday, November 01, 2007 1:48 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 14, 2013 11:41 AM
Points: 120, Visits: 61
Comments posted to this topic are about the item List SQL Server Jobs


Post #417411
Posted Wednesday, August 17, 2011 12:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 5:58 PM
Points: 8, Visits: 82
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 »

Add to briefcase

Permissions Expand / Collapse