|
| I would update on this sp_hook_dbmlsync_dow
nload_table_end does provide the prior download time.
It is only the sp_hook_dbmlsync_dow
nload_end.
I had too many debug insert records to see what was going on & didn' see the correct value got in in the download_table_end event.
So that will work for me.
But, is there a way to get the last_download_time in the download_end event?
Also,
select last_download_time from
SYS. SYSSYNCSUBSCRIPTIONS
where
publication_name = 'pub_remote_page'
Is there a system function to get this?
thanks
vsv
[color=darkred]
Requirement:
I want to obtain the list of all records that are being downloaded (update/insert) into a table & process
those records to populate other table in remote only.
env: asa 9.0.2.2451 remote db
ase 12.5.1 consolidated
I am trying to accomplish this using the last download time.
How to get the prior download time in the remote DB in sp_hook_dbmlsync_dow
nload_end & sp_hook_dbmlsync_dow
nload_table_end ?
The last download time from this query that I use
select last_download_time from
SYS. SYSSYNCSUBSCRIPTIONS
where
publication_name = 'pub_remote_page'
(Is there a system function to get this? )
gives the current download time & not the last download time during a synchronization process in the sp_hook_dbmlsync_dow
nload_end & sp_hook_dbmlsync_dow
nload_table_end event.
However, sp_hook_dbmlsync_dow
nload_begin does gives the last_download_time.
As of now the alternative i have is to store the value in a user temporary table during sp_hook_download_beg
in event.
But I would like to avoid doing that.
Thanks in advance
vsv
|
|