I found this on Thwack, but is there any way to create a schedule in SQL ? (to run this command everyday at 23:00)
UPDATE dbo.Interfaces SET Unmanaged = 1, UnManageFrom=GETDATE(), UnManageUntil=DATEADD(year, 1, GETDATE())
WHERE Fullname like 'BuildingE_Switch%'
You could do it with a SQL Agent job.
However, there is an easier way to do it.
NPM includes an "Unmanage schedule" utility. This wizard based util creates an object that you run as a scheduled task on the NPM server and it accomplishes what you're seeking.