The reason I think it is linked server problem is because when I remove the select ... from linked server line in the trigger the merge agent works just fine.

I...

The replication agent connection to Publisher uses SQL Server Authentication called dbUserAccount. I test this account in QL and worked fine.

The linked server login is also SQL user...

Hi Csaba,

Do you change you local system account password? If so you can try this:

Open system services Click MSSQLSERVER or SQLSERVERAGENT then properties under log on tab check the Local...

Do you have any example for such robust script method?

It is pretty strange. I started a job this morning at 6:00, it run another time at 7:00, then stopped...

Yes,but hard to restart. It says the job is executing by another schedule. So I had to stop the SQL agent and restart it.

Thanks mccork,

I do find the result from ¡°View Job History¡±. It says: Job "MyJob" is not executing. No action necessary [SQLSTATE 01000] (Message 0). The step succeeded....

Hi, mccork,

I got the script run on my server, but I can’t figure out how to check the result. Where is the Log file?

Do I need to save it to...

Thank you mccork,

Could you give me an example script for detecting job execution? We do have the ftp site temporarily unavailable, network down problems sometimes, the problem is after them...

Here is a example:

Step 1: run a DTS job: DTSRun /~Z0xEEE636F80548F73BA5EF00A188020419240846A5997A9C43D83FB3FFFB45BD53333A443666903946F30BA9567E487415C37678474BFDEB13786E3197438AF920742AA740327BBF834A7244374B5F0B900DBE91

Step 2: run a script:

set nocount on

create table #ftp_script (

...

No.

One is a merge agent,another one is created by myself for sending data to a ftp site, it uncategorized.

thanks.