Re: Question about "Distribution clean up: distribution" Job

Hi Ken,

I am guessing that the SQLServerAgent service does not have sufficient
rights to remove folders under P:\ReplData. As such, you may want to try
right-clicking the folder in Windows Explorer and grant the SQLServerAgent
service account Full Control rights on it.

-Raymond

"Ken Powers" <KenPowers@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4F98FEE4-6C0D-4274-A6C4-8384EADB82A9@xxxxxxxxxxxxxxxx
It is SQL Server 2005 and xp_cmdshell was already enabled.

"Hilary Cotter" wrote:

Is this SQL 2005? If so you need to enable xp_cmdshell.
If it is SQL 2000 you need to ensure that no one else is accessing this
directory.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Ken Powers" <KenPowers@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E882295-B0F5-4FA8-A3ED-731CFB672615@xxxxxxxxxxxxxxxx
Can the manner in which you remove a publication effect the ability of
this
job to run?

I had been experiencing errors with this job. The error message was as
follows:

"Executed as user: <SQLServerAgentDomainAccount>. Could not remove
directory
'P:\ReplData\unc\YKCLNSE_CLGWAREHOUSEPROD_STAGINGDAILYADT\20061221142453\'.
Check the security context of xp_cmdshell and close other processes
that
may
be accessing the directory. [SQLSTATE 42000] (Error 20015). The step
failed."

I run my SQL Server Agent process with an account that does not have
sysadmin rights. After reading a few other posts with this same error,
I
experimented with running the job as a user with sysadmin rights.
Unfortunately, I still had the same error.

Then I went into the job step and copied the command it was attempting
to
run. This is the command:

"EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0,
@max_distretention = 72"

I pasted this command into a query window and attempted to run it under
my
own login, which is a member of the sysadmin role and is also a member
of
the
Local Administrators group. It still could not run.

The folders the command was trying to delete were used for Publications
that
no longer existed. So I went ahead and deleted the folders manually.
Now
the command ran successfully.

I am thinking something went wrong during the process of removing the
publications and subscriptions. Anyone have any idea what might have
happened?





.

Relevant Pages

  • Re: Inherited rights
    ... I was setting up manual rights to files and folders and forgot to re-activate one of Adobe's folder and sub-folders. ... If I could simply re-activate it via a registry entry or DOS command, I would be able to re-activate these rights on multiple workatations deployed in our department! ...
    (microsoft.public.windowsxp.general)
  • Folder rights
    ... Is there a program that will create a report on all rights ... granted to folders on a win2k data server? ... could use the "Rights" command like option and pipe it to ...
    (microsoft.public.security)
  • Success
    ... secure Windows, IIS, IE, Outlook Express ... >different upload and download folders. ... >Third party FTP software, or OpenSSH, or VPN can be used ... >1) Use a "DOS" Command Prompt for the steps below. ...
    (microsoft.public.inetserver.iis.security)
  • Re: system folders not shared?
    ... It is amazing how much can be accomplished at a command line. ... I still could not access XP's system folders. ... files would open across the network but media files would not). ... permissions to block the sharing of certain folders. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Vanishing icons on Desktop and in Recycle Bin
    ... Use the command prompt ... I couldn't see a SID #. ... Both of those SID # folders should open, ... My INFO2 opens. ...
    (microsoft.public.windowsxp.help_and_support)
Loading