On the export process status page, select the Job schedules tab and click Add. The Create job screen appears.
In the Job name field, enter a name to help identify the scheduled job.
In the Schedule type field, select the frequency to run the job.
To run the job only once, select "One time." The One-time occurrence frame is enabled.
To run the job every day, select "Daily." The Frequency, Daily frequency, and Duration frames are enabled.
To run the job every week, select "Weekly." The Frequency, Daily frequency, and Duration frames are enabled.
To run the job every month, select "Monthly." The Frequency, Daily frequency, and Duration frames are enabled.
To run the job with the SQL Server Agent service, such as if you use the SQL Server Agent service with other tasks, select "Start when SQL Server Agent service starts."
To run the job when enough resources are available on the server, as determined by the Idle condition defined in the SQL Server Agent properties on the server, select "Start when the computer becomes idle."
To mark the schedule active, select Enabled.
If you select "One time," under One-time occurrence, select the time and date to run the job.
If you select "Daily," under Frequency, in the Occurs every [ ] day(s) field, select how often to run the job. For example, select "2" to run the job every other day.
If you select "Weekly," under Frequency, in the Occurs every [ ] week(s) on field, select how often to run the job, and select the day of the week to run the job.
If you select "Monthly," under Frequency, in the Occurs every [ ] month(s) on field, select how often to run the job, and then select a calendar date or general date frequency to run the job.
To run the job the same date each month, select Day and, in the [ ] of the month field, enter the date. For example, to run the job on the 15th of the month, enter "15."
To run the job at a general frequency each month, select The and, in the[ ] [ ] of the month field, enter the frequency. For example, to run the job on the first Sunday of the month, select "First" and "Sunday."
If you select "Daily," "Weekly," or "Monthly," under Daily frequency, select whether to run the job one time or multiple times on the day selected under Frequency.
To run the job one time on the selected day, select Occurs once at and enter the time of the day to run the job.
To run the job multiple times on the selected day, select Occurs every and enter the frequency to run the job, such as "30 minutes." In the Starting at and Ending at fields, select a time range to run the job at the selected frequency. For example, to run the job overnight during off-hurs, enter select a start time of "12:01:00 AM" and an end time of "5:30:00 AM."
If you select "Daily," "Weekly," or "Monthly," under Duration, in the Start date field, enter the date to start the job schedule and select whether the schedule has and end date. If you select End date, enter the date to end the job schedule.
Click Save. You return to the Job schedules tab. In the grid, the new job schedule appears.