[sims] Schedule a patch to apply via dbUpgrade

[panosthegreat]

Background: We've got an issue with FMS and SIMS Finance clashing and locking our finance department out of SIMS. They get an error saying 'this file is in use by another user' and can't then do any work until I run a patch that Capita have sent me (11665 Unlock Patch). Restarting the server without applying the patch doesn't work as they remain locked out, and it can only be applied when nobody is on SIMS

 

So, I was wondering whether I could create a .bat file to add to the task scheduler on our SIMS server so every night it runs at midnight to save me having to remote in and apply it? It's applied through the SIMS Database Upgrade Tool (dbUpdate)

 

Anyone done anything similar? I've not had much luck searching online

[Esteban_Child_of_the_Sun]

AS the Patch is very simple

UPDATE sims.fees_multiuser_check SET locked = 0, user_id = NULL, locked_date = NULL WHERE locked = 1

You could just schedule it in SQL Management Studio

https://itknowledgeexchange.techtarget.com/itanswers/how-to-schedule-sql-query-to-run-in-microsoft-sql-server/ (just remember to schedule it to do a backup first).

However, Capita would still probably complain about you executing their own code outside of DBUpgrade. You can run DBUpgrade from the commandline with the /? parameter to get the command line options for scheduling it as a task.

[panosthegreat]

Thanks Esteban

I've had a go at your 2nd suggestion about running DBUpdate from command line which i can put into a batch file and schedule. Will test tonight. I was just a computer science teacher last year, feel like I'm hacking into the matrix at the moment haha