Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 customize jobs in log shipping

Author  Topic 

HaoVV
Starting Member

1 Post

Posted - 2011-09-27 : 06:17:52
hi all,

I got a big problem about log shipping, I don't know how to get exactly next run time of copy and restore job.
example:
first of all (Copy job): I configure copy job
last run: 10:12:00
next run: 10:22:00
(frequency 10 minute)

then, I want to reconfigure with frequency 15 minute. but I got result below:
last run: 10:12:00
next run: 10:18:00

(exactly result must is :
last run: 10:12:00
next run: 10:27:00)

I don't know why?
please help me to clear it. thanks so much!
(My English too bad )

--

Vo Van Hao

biswajitdas
Starting Member

44 Posts

Posted - 2012-01-11 : 14:00:21
did you reconfigure the job at 10:03:00 ?


Sr Sql server DBA/Artitech
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-01-11 : 15:28:36
In the job schedule, change the "starting at" parameter to 12:12am.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -