Overview

There is a process that is adding data to one of your queues and you would like to stop it since it is not in use at this moment. Also, you want to resume the same process at any moment.

Information

Stopping / Pausing a job

You can stop and resume a job to happen in ResourceOne. To do so, complete the following steps at the DB level:

1. Connect to your DB instance.
2. Locate the job you want to stop, by scrolling down to SQL Server Agent > Jobs > The job you are looking for:
   
   
   I took the R1 Maintenance job for this example.
   
   
3. Right click on it and select Disable.
   
   
   
   
4. Check the <RESOURCEONE_INSTALLATION_PATH>/muu/DataFiles and see of there is a CSV file that triggers this process. (You will know because of the name. For example, the maintenance job will have as an input a maintenance_triggers.csv file).
   
   
   
   
   • If there is a CSV file, it means that this file is the input for that process and thus, must be backed up outside this folder. To back this file up, create a folder with the same name of the CSV (for this example it would be a folder named maintenance_triggers) and put this CSV file inside this folder, removing it from its original place.
     
     
   • If there is no CSV file inside this DataFiles folder, then the process of stopping/pausing the job has concluded.

Once you stop or pause the Job, you will see that it stops happening after 24 hours (when the other jobs run).

Starting / Resuming a job

You can start (or resume) a job or trigger in ResourceOne. To do so, complete the following steps at the DB level:

1. Look for the backup folder by checking the <RESOURCEONE_INSTALLATION_PATH>/muu/DataFiles folder and confirm if there is a folder with the name of the process you are looking to reactivate and "_BK" as suffix. (For example, the maintenance job will have a backup folder named maintenance_triggers_BK. This "triggers" word resembles the name of the CSV file inside of it).
   
   
   
   
   • If there is such a folder, Check if it has a CSV file inside. If so it means that this file is the input for that process and thus, must be restored to the original folder. To restore this file up, cut it and put this CSV file inside the original <RESOURCEONE_INSTALLATION_PATH>/muu/DataFiles folder, removing it it from this backup folder as well. Then, continue to step 2.
     
     
   • If there is no backup folder or there is no CSV file inside this backup folder, then you can continue to step 2.
     
     This first step is crucial, because this file is the input file for the job you are looking to resume. If you don't follow it, even when executing this whole procedure the job won't work properly.
2. Connect to your DB instance.
3. Locate the job you want to stop, by scrolling down to SQL Server Agent > Jobs > The job you are looking for:
   
   
   I took the R1 Maintenance job for this example.
   
   
4. Right click on it and select Enable.

Testing

To test if the job started properly, you must wait at least 24 hours, to ensure that all the jobs and processes ran as intended. Once 24 hours has passed, log into your ResourceOne instance, and complete the following steps:

1. Open the queue you are working with, by clicking the Queues > Opportunities menu (at the left side of the screen).
   
   
2. Confirm that the job ran at least once in the last 24 hours and some records were created in that time lapse. That can be confirmed by checking the date of these new records under the ADDED column. (It should match with today's date, or maybe yesterday, depending when the job ran).
   
   
   
   
3. Check if the Job History logged any error for this particular job, or if instead, this job and every step of it was marked as successful.