Posted by Greg D. Moore \(Strider\) on 02/19/07 14:09

"shark" <xavier.sharon@gmail.com> wrote in message
news:1171893846.907975.280580@a75g2000cwd.googlegroups.com...
> Hi all,
>
> i have sql servr 2000 standard edition.
> robocopy is a step in one of the jobs. this step fails in the job
> where as when i run it from command prompt the same command exceutes
> succesfully. i have given the owner of the job as sa. acctaully wheni
> see the files have been copied to the server succesfully but still
> this step is shown as failed in the job.
>
>

It appears that whatever user Sql Agent is running under does not have
rights to the UNC you are using.


>
> Executed as user: PRODUCTION\SVC_SQL025. ...--------- ROBOCOPY v
> 1.96 : Robust File Copy for Windows NT
> ----------------------------------------------------------------------
> Started : Mon Feb 19 09:00:33 2007 Source : G:\server\data\mssql
> \BACKUP\RRU\AWDDATA\ Dest : \\sgcfhpsql25\g$\server\data\mssql
> \LogShipping\awddata\AWDDATA_DB_BACKUP\ Files : *.*
> Options :*.* /R:1000000 /W:30
> ---------------------------------------------------------------------
> 2 G:\server\data\mssql\BACKUP\RRU\AWDDATA\
> New File 1166963200 AWDDATA_db_200702190900.BAK 0.0%
> 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
> 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.1%
> 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1%
> 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.1% 0.2% 0.2%
> 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2%
> 0.... Process Exit Code 1. The step failed.
>
> Can any body guide me?
>
> thanks for the help.
>
> Shark.
>



--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com

[Back to original message]