How can we help you today? How can we help you today?

change schedule for restore job

I have setup a logshipping job to occur every 15 minutes. I would like to make it occur every 10 minutes, so I opened the GUI & edited the schedule for the backup job to run every 10 minutes, and then when I tried to edit the schedule for the restore job (on the remote server) to run every 10 minutes I got an error message that:

"The GUI does not support editing the command you selected."

Please advise how can I change the schedule for the restore job to occur every 10 minutes.

Thank you!
vad2319
0

Comments

2 comments

Sort by
  • petey
    You can edit the SQL Server Agent job directly using Enterprise Manager or SQL Server Management Studio. Look for the restore job, then change the schedule to the interval you want.
    petey
    0
  • vad2319
    Thank you!
    vad2319
    0

Add comment

Please sign in to leave a comment.