Before you begin
You must have access to run SQL jobs in the database server at your practice.
This can be a one-time only process, or, it can be set up to automatically occur at periodic intervals of your choosing.
- Open SQL Server Management Studio in the database server.
- In the Object Explorer pane, expand .
- Right-click the bulk enrollment job (<Database name> - bulk invites enrollment) and select Properties.
The Job Properties window opens.
- In the Select a page pane, select Steps.
- In the Job step list section, select the step and Edit.
- In the Command field, enter the parameter values in the DECLARE script and select OK.
- In the Job Properties window, on the Select a page pane, select Schedules, and then select New.
The New Job Schedule window opens.
- Enter a name for the schedule.
- Select a Schedule type from the list.
- To run the schedule One time, in the
One-time Occurance section, enter the Date and Time.
- To run on a Recurring schedule, enter the values in the Frequency, Daily Frequency and Duration sections.
- Select OK.
- In the Job Properties window, select OK.
To view the history of the SQL query run, right-click <Database name> - bulk invites enrollment and select View History.
