Enabling and disabling flight in Cloud Hosted VM, Sandbox and Production server in Dynamics 365 F&O

 

if you want to disable the flight in cloud hosted VM's then you need to run below command in SQL by replacing your flight name in place of <FlightName>. 

The "_KillSwitch" is important because this indicates turning of the flight.

INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED, FLIGHTSERVICEID) VALUES ('<FlightName>_KillSwitch', 1, 12719367)

if you want to enable the flight then if you just delete above entry then it will be enabled back(if you flight defaulted only). if not then you need to run below statement to enable your flight in SQL.

INSERT INTO dbo.SYSFLIGHTING(FLIGHTNAME, ENABLED, FLIGHTSERVICEID) VALUES ('<FlightName>', 1, 12719367)

In case of sandbox and Production servers, we will not be able to turn on or off by our self. we need to log a ticket with Microsoft support team and they can help you with the same. 

#Flight #X++ #Dynamics 365F&O #EnableFlightInSandbox #EnableFLightInProduction #DisableFlightInSandbox #DisableFLightInProduction