Creating a New Scheduled Backup Job

Use the Add Scheduled Job wizard in SAP Control Center to schedule a backup job.

  1. In the Administration Console view, expand ASE Servers > Task Management
  2. Click Scheduled Jobs
  3. Select New.
  4. In the Introduction screen, select the server for which to schedule the backup job.
  5. In the Job Name screen:
    • Enter a name for the scheduled job
    • (Optional) Enter a description for the job.
    • If you installed the Job Scheduler template in the server you selected, you see Use a JS template to create this job. Select this to use the template.
  6. If you selected Use a JS template to create this job:
    1. Choose a backup template from the Backup Template screen.
    2. In the Target Server screen, select:
      • The local Job Scheduler target server, which is the same as the server you selected. You can then select a database from the local Job Schedule target server.
      • A remote Job Scheduler target server listed in the sysservers system table, after which, you specify a database on that remote target server.
  7. If you left Use a JS template to create this job blank, you see the Job Command screen. Enter the SQL syntax for your backup job. In the target server page, select either the local target server or the remote target server on which the backup schedule job is to be executed.
  8. In the Select Schedule screen, choose one of:
    Option Description
    Use existing schedule Select a schedule from the table
    Create new schedule A field in which to enter a new name for the schedule field.
    Note: From this point in the wizard, click Preview at any point to view the SQL syntax for your selected options.
  9. If you are using a backup template, you see the Backup Template Options screen:
    Option Description
    Dump location (Optional) Specify the location to which to dump the database. Job Scheduler uses the default location if you leave this field blank.
    Server name Use server name in dump filename.
    Date format Use date format in dump filename.
    Number of stripe files Specify how many dump stripe file will be generated.
    Compression level Data compression mode in dump operation.
  10. In the Job Options screen, select all that apply:
    Option Description
    Allow multiple concurrent executions Allows you to run your job concurrently, except for jobs that may interfere with another instance of itself, such as dbcc reorg.
    Allow others to use this job Gives permission to others to use the schedule and execute your job.
    Always execute as the job owner Specify this if you want all executions of this job to occur under your login.
    Timeout Specify a numeric value, in minutes. If the job does not complete in the amount specified, the job is terminated.
    Note: You can override this value for individual scheduled jobs.
  11. In the Job Execution Option screen, select all that apply:
    Option Description
    Do not log output from job By default, any output generated by a job is saved and can be viewed in the Job Histories folder. Select this option to suppress output from the job you are scheduling. By default, it is unselected.
    Allow others to execute this scheduled job Allow others to be able to execute this job. By default, this is unselected.
    Disable on failure Disable the job if its previous execution failed, and suspend all scheduled executions of the job until you manually re-enable it.
    Delete on completion Delete the scheduled job when it finishes executing. This is useful for jobs that do not recur.
    Note: Choosing this option does not delete the underlying job or schedule.
  12. (Optional) Click Summary to verify your selected options.
  13. Click Finish to schedule the job.