Adjust the Schedule of an SQL Job

Adjust the frequency of the recurring SQL jobs that the portal performs.

Examples of recurring SQL jobs include refreshing employee groups, updating Personal Information fields to Vista, and sending reminder emails for approvals or timecard entry.
  1. Log in to SQL Server Management Studio as a System Admin.
    You will connect to the SQL server where your Vista and KDS-HRIM databases live.
  2. Expand SQL Server Agent, and then expand Jobs.
  3. Locate the KDS-HRIM_RefreshUSerGroups job.
    Note: All portal jobs begin with KDS-HRIM_ followed by the name of the function.
  4. Right-click and select Properties.
  5. Navigate to the Schedule tab.
  6. Click New to add a new schedule or Edit to modify an existing schedule.
  7. Configure the SQL job schedule as desired. Options will be similar to the following sample.
    • Select No end date in the Duration area.
    • After you finish adjusting the schedule, select OK.

  8. If you have multiple schedules set up for a single job, the job will run on each of those schedules. No single schedule cancels out another. If you want the job to run on a single schedule, remove the unnecessary schedules.
  9. When you are finished, click OK.