How do I schedule the Year End Circ Count Rollover job?

The Year End Circ Count Rollover job can be used once annually to rollover the item, bib, and patron circulation counters to previous year tables and zero out the current year-to-date counters.

If you have access to SQL, you can schedule this job by following the steps below:

1. Access SQL Server Management Studio for the Production server using Windows Authentication to login (no username or password will be required).
2. In the Object Explorer, expand the SQL Server Agent.
3. Double-click on "Job Activity Monitor."
4. Find the Year End Circ Count Rollover job in the list. If the job is not enabled (yes or no will be listed in the Enabled column), right-click on the job, and select "Enable Job."
5. Double-click on the job to open the Job Properties window.
6. Click on Schedules and select "New" to open the New Job Schedule window.
7. Type a name for the schedule, and ensure that the Enabled box is checked.
8. Select a schedule type, either Recurring or One Time.
9. If you choose One Time, specify the Date and Time for the job to run. Remember that the job should run when the library is closed.
10. If you choose Recurring, the job can be set to run, for example, every 1st day of every 12 months:
    1.Schedule the run day in the Frequency section by selecting Monthly and then Day 1 of every 12 month(s).
    2.Schedule the run time in the Daily frequency section by typing the desired run time in the "Occurs once at" field, e.g., 12:01 AM. (This time usually works well, but double check that no bibliographic or patron related jobs are scheduled for the same time.)
    3.Select the start date in the Duration section, e.g., 1/1/2014. If you would like the job to run every year on this date, select "No end date." Otherwise, specify an end date. (Note: The start date specified when you set a recurring schedule must be in the future. According to, the SQL Server Management Studio local help file, the start date indicates "when the schedule will become effective.")
    4.Read through the Summary Description to make certain it matches your desired schedule. If not, make your changes until it does.
11. Click "OK" to return to the Job Properties window. Your new schedule should appear.
12. Click "OK" to return to the Job Activity Monitor. Verify your job is scheduled to run as expected in the "Next Run" column.
13. Click "Close" to exit the Job Activity Monitor.
    
    

The Year End Circ Count job is now successfully scheduled. After the job completes, check the YTD statistics for items that were circulated the previous year. The YTD count will be zero. If it is not zero, please check the SQL Server Agent to ensure that the job was scheduled and run properly.

Draft Solution: 160907153854067 Year end circ count rollover job

FOR HOSTED LIBRARIES: do not set this job to run anytime between 11:45pm and 12:15am as the server can reboot and cause the job to fail mid-run. Set the job to run at 12:45am the day the library would like it to run (for example, 12:45am on January 1st each year).