sql server 2000 robo copy

[shark]

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.

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 D. Moore \(Strider\)]

"shark" <xa***********@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.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