How to Disable Scheduler Jobs After a Refresh

We would like scheduler jobs in a non-production environment disabled after a refresh from production.

• Database Refresh
• Munis Scheduler
• Scheduler Jobs

Informational

Option 1- Manually disable individual jobs via the Scheduler Queue:

1. Sign into the refreshed Munis environment with an account with administrative rights
2. In the Tyler Menu navigate to System Administration>Scheduler Administration>Scheduler Queue
3. Click and highlight the job(s) that you do not want to be enabled then click Job>Hold to place the job on hold or Delete to remove the job entirely

Option 2- Adjust the refresh script to automatically place all scheduler jobs on hold in the non-production environment:

1. Sign on to the Munis Application server as the Tylerservice user or equivalent
2. Open File Explorer and navigate to the data drive
3. Open the cmd folder
4. Right click on refresh(env).cmd > edit with notepad ++
5. Scroll to the bottom of the refresh script
6. Paste the query below at the end of the refresh script. This query will put all jobs in the refreshed environment into a hold status 

   UPDATE skedqueu
   set skqu_status = 'ON HOLD'

7. Click Save

8. Run the refresh as needed

How to Refresh a Non Production Munis Database