Delete or Modify Mongodb records

[nraghavak]

Hi,

I need to take a backup of Prod data into another test environment but i do not want those schedules to run again on test. And i use embedded mongodb as part of server installation.

Hence intending to delete these copied schedules from mongodb on test environment before making test server live, whether anyone has played by doing any alterations to mongo db and how was your experience?

Also you got any other recommendations on how to disable schedulers on another environment?

Thanks,

Rag

[David-Carnes]

Hi @nraghavak!
There are two ways to do this.  Before you restore from production, go into the the Alteryx System Setting and change the Worker Configuration by either
1.  Unchecking the Run unasssigned jobs under Job Assignment.

Or

2.  Unchecking Allow machine to run scheduled Alteryx workflows.

https://help.alteryx.com/20214/server/worker

Hope this helps!

Best,

David

[nraghavak]

Hi David,

Thanks for solution.

If understood correctly, uncheck these options on Prod then take a backup. After taking a backup, undo the changes in Prod. Then restore this backup data on Test?

I have tried this but this automatically get checked again while restoring on Test server?

Thanks,

Rag

[nraghavak]

Also would like to know your experiences if you have tried to tamper embedded mongodb like updating or deleting few records etc.?

[David-Carnes]

You need to turn off the ability to run schedules on the test box, not on production.

I have attempted to alter the MongoDB but the user account doesn't have permissions for that.

[nraghavak]

Hi David, thanks but i need other workflows to still run as per the schedule on test. So when i checked again on test, what happens to those prod jobs on test, i do not not want them to ever run on test environment

[David-Carnes]

Well, I usually delete all the schedules in Gallery (Admin), then go back to the server to delete all the items in the queue.  (Open Designer on the test server, view schedules, queue tab.  They pile up but can't run.)

In your case, delete the unwanted schedules in in Gallery, keep the ones you want, delete the items in the queue (there's a little button with a minus sign). Maybe that's what you need?