Clear-ASMonitoringSqlDatabase cmdlet in non-interactive mode

[acelestial]

Hi,

I'm trying to automate running of powershell command below in non-interactive way. The command prompts for a confirmation.

Is there a way to bypass the confirmation prompt or accept the default confirmation response in the command/script so that it'll run automatically?

Clear-ASMonitoringSqlDatabase -ConnectionString "Data Source=localhost;Initial Catalog=Monitoring;Integrated Security=False;User ID=xxx;Password=xxx" -MaxAge 3 -PurgeMode EventAgeMode

Any help is much appreciated!

Regards,

Arman

[#2]

@acelestial  put a -force

Clear-ASMonitoringSqlDatabase -ConnectionString "Data Source=localhost;Initial Catalog=Monitoring;Integrated Security=False;User ID=xxx;Password=xxx" -MaxAge 3 -PurgeMode EventAgeMode -force

[#3]

@gastone  Clear-ASMonitoringSqlDatabase cmdlet has no  either -Force or -Confirm options.