http://www.sqlservercentral.com/Scripts tagged Maintenance and Management, Job schedules posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/ Which did not work in SQL 2005 due to table changes on MSDBhttp://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/2008/03/21http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/