Manage Scheduled Jobs

Edit, run, view the history of, and delete existing Scheduled Jobs in the portal.

To create / add a new job instead, see Create a New Scheduled Job.

Note: Scheduled Jobs replaced SQL jobs (starting in version 23.2), which were previously managed in the SQL Server Management Studio. Scheduled Jobs are managed in the portal.
  1. Go to Admin > Portal Settings. In the Administrative Actions section of the Portal Info tab, select Scheduled Jobs.
  2. Select Action to view your options for managing a particular job.
  3. To update the schedule and enable / disable a job, select Edit.
    Note: The usage data (usage-data) scheduled job may not be changed or disabled.
    1. Update the Schedule field by entering the cron expression for the time you want the job to run on.
      Note: Schedule inputs must be in a valid cron string format.
      • To generate a cron expression that you can paste into the Schedule field, go to crontab.cronhub.io.
      • Example of a cron expression: 30 2 1 * * means that your Scheduled Job will run at 2:30am, on day one of the month.

      On the Scheduled Jobs page, the schedule is listed in standard time format.

    2. Select the Enabled checkbox to run the job on your defined schedule.
      Deselect this checkbox to turn off the job (disable it) without deleting it. You can turn the job back on again (re-enable it) at any time.
    3. Select Save.
    4. To return to the Scheduled Jobs page, Cancel out of the Edit window.
  4. To view the history of the job, select Action > History.
    Job history details include the time and date of the job when it was run, the state of the job at that time, and a message about the job.
    Note: Scheduled Job history is logged from version 23.4 and forward. Job history prior to this version is not included.
  5. To manually run a job, select Action > Run.
  6. To completely delete a job and remove it from the list of Scheduled Jobs, select Action > Delete. You can only delete user-defined jobs.
Note: After editing a job, the User Defined and Enabled column x and checkmark icons will refresh accordingly.