Adjust the Schedule of a 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.
Important: Beginning with version 23.2, SQL jobs are being replaced with Scheduled Jobs, which are managed in the portal. Jobs will no longer be managed through the SQL Server Management Studio.

Before updating to the 23.2 version, review your custom SQL jobs, as these will be deleted. If you modified any of the default SQL jobs, you will need to update the schedule for these customized jobs on the Scheduled Jobs page. You will not need to update portal settings associated with these jobs—they will carry over and remain in effect.

For more information, see Scheduled Jobs.

  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.
    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. Select 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, select OK.