Skip to Content
avatar image
Former Member

Job scheduling

Hello,

How can I set up a job in production with the following details:

Job runs from Mon-Fri only between 2:05 pm - 2:05am (next day) with interval of every 2 hours.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 21, 2010 at 06:54 PM

    Create 5 jobs, one per day and define start date, time and end date, time and periodic for two hours from time you start and doesn't run after 2.05 a.m. on 2nd day.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 09:14 PM

    what job you want to schedule.

    are these DBA actions job. usually data back up and log backup jobs are scheduled 2 hourly

    Regards,

    Surpreet Bal

    Add comment
    10|10000 characters needed characters exceeded