CREATE JOB Backup
RUN AS "System"
FROM DATE '2008-01-01' TO DATE '2010-01-01'
EVERY 7 DAYS
BETWEEN TIME '01:00 AM' AND TIME '01:30 AM'
BEGIN
   EXECUTE IMMEDIATE 'BACKUP "RCS" AS "' +
      CAST(CURRENT_DATE AS VARCHAR(10)) +
      '" TO ''\Backups'' INCLUDE CATALOG';
END