run the following
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -pAll the junk I have in my head
All the junk I have in my head
Quick to disable and enable all SQL jobs on your server
USE MSDB
-- DISABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1
-- ENABLE ALL SQL JOBS
UPDATE dbo.sysjobs
SET Enabled = 1
WHERE Enabled = 0Adding app_offline.htm to the root of your .net application automatically shuts it down. Very nice for putting up a quick maintenance page.
Leave a Comment