RE: Distibution db cleanup will not run

From: Baisong Wei[MSFT] (v-baiwei_at_online.microsoft.com)
Date: 02/02/04 

Date: Mon, 02 Feb 2004 13:16:01 GMT

Hi John,

Thank you for you feedback.

Well, since no other processes are using the directory, the possiblity of
this factor could be ignored. The 'sa' could be the owner of the agent
owner, or the job owner of the clean up job ( you could unfolder the
'Replication Monitor'->'Agent'->' Miscellaneous Agents', right-click the
'distribution clean up: distribution', choose 'agent properties' and check
it in the 'General' tab; Or you could unfolder 'Management'->'SQL Server
Agent'->'Job', right-click the job 'distribution clean up: distribution'
and in the 'General' tab, checking the owner). However, as I mentioned
before, that it will finally run 'xp_cmdshell' to delete the directory, you
should check the account which start the SQL Server Agent.

You could get this information by right-click the 'SQL Server Agent' in the
'Management' and choose 'Properties', in the 'General' tab, you will see
the Start Service Account. Please confirm this account could run
'xp_cmdshell' to READ and WRITE the directory instead of the job owner.
Also, could you provide the agent 'Distribution Clean Up: distribution''s
history by right-click it and choose the 'Agent History'?

Looking forward to your reply! Thanks

Best regards

Baisong Wei
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Relevant Pages

  • Re: Consumer Notice ?
    ... You couldn't make a direct deal with the owner anyway. ... property is listed for sale by a realtor, ... If the house sells, it sells via the agent, ... and they get a commission regardless of how you ended up finding this ...
    (misc.consumers.house)
  • Re: Need advice about Proxy and IP
    ... being the beneficial owner. ... A "registered agent" for your LLC could be used, ... payment option. ...
    (alt.privacy)
  • Re: Real Estate Fraud/Idenity Theft, Tenant Questions
    ... The real estate agent and the supposed "true" owner are coming by to ... install new door locks. ... The agent says yes because I don't have any agreement with her client ... I told "my" landlord about ...
    (misc.legal)
  • Re: Agent Deadlock Errors
    ... contributes to your deadlock problems. ... queued agent to run on a staggered schedule to the distribution clean up, ... > subscribers-with queued updating as failover. ...
    (microsoft.public.sqlserver.replication)
  • Re: Consumer Notice ?
    ... You couldn't make a direct deal with the owner anyway. ... property is listed for sale by a realtor, ... If the house sells, it sells via the agent, ... the buyer to pay any commission beyond what is specified in the listing ...
    (misc.consumers.house)