If we define a task to be run at a specific time daily, when does the task stop running and wait for the timestamp on next day?
Also, if it is defined this way, are all the changes captured - between when it stopped the previous day and started at the given time on the current day?
Yes, this is possible. If your task is in the CDC phase and capturing changes and you stop the task it will save positions in state files do it will know where to begin capturing changes.
Whey you schedule the task to start you must start in resume mode - as this will allow the task to pick up where it left off.
With this set up the task will capture all the changes that occured from when it was stopped.
Please do make sure that the source transaction logs are retained on disk for enough time between the stop and restart (resume).
The task will continue to run unless you also schedule a time for the task to stop (via a separate scheduled job).
Yes, when the task runs (using the "run task" option) it will resume from when the task most recently stopped. You will need to ensure the source redo/transaction logs are available going back to when the task last ran.
Yes, this is possible. If your task is in the CDC phase and capturing changes and you stop the task it will save positions in state files do it will know where to begin capturing changes.
Whey you schedule the task to start you must start in resume mode - as this will allow the task to pick up where it left off.
With this set up the task will capture all the changes that occured from when it was stopped.
Please do make sure that the source transaction logs are retained on disk for enough time between the stop and restart (resume).
The task will continue to run unless you also schedule a time for the task to stop (via a separate scheduled job).
Yes, when the task runs (using the "run task" option) it will resume from when the task most recently stopped. You will need to ensure the source redo/transaction logs are available going back to when the task last ran.
