Setting up an hourly schedule during business hours

pbanghart

ADSM.ORG Member
Joined
Sep 16, 2002
Messages
40
Reaction score
0
Points
0
Website
Visit site
PREDATAR Control23

G'day...



My SQL gurus are asking me to schedule their TDP backups from the central scheduler...I can do the once-a-day full backup schedules no problem, but they also want to do hourly transaction log backups from 5am to 7pm, Mon-Fri only.



I thought I could set up a script to run daily that would define a schedule with a start time of 5:00am, but the schedule expiration is by date, not by time, so I can get the schedule to stop at 7:00pm as desired.



Has anyone out there already done something like this?

:confused:





-PB
 
PREDATAR Control23

Create a schedule with a duration of 30 minutes and a period of 1 hour. Set Day of Week to weekdays. Your script will need to know when to run, because there is not a stop time. That should work, it was in the class I took, but I have not done it, we use another scheduler for SQL.



define schedule DOMAIN_NAME 1_hour_sql action=command objects=BACKUPSCRIPT starttime=05:00 duration=30 durunits=minutes period=1 perunits=hours dayofweek=weekday

This will start running at 5am Monday and stop running 23:00 Friday.





That may be the command, use at your own risk!





Andy
 
Top