Link to home
Start Free TrialLog in
Avatar of hraja77
hraja77

asked on

Running o/s job though sql server

Hi,

I am running a job through sql server and get the error below when trying to copy across a remote server as below - any ideas why i get the error ?


Job 'Restore CSS Reporting' : Step 1, 'Copy Production CSS' : Began Executing 2011-09-27 15:51:51

output                                                                                                                                                                                                                                                        
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(null)
C:\WINDOWS\system32>echo wscript.echo year(date) & right(100 + month(date),2) & right(100+day(date),2)   1>"C:\WINDOWS\TEMP\dateparts.vbs"
(null)
C:\WINDOWS\system32>for /F "tokens=1 delims=" %a in ('cscript //nologo "C:\WINDOWS\TEMP\dateparts.vbs"') do set yyyymmdd=%a
(null)
C:\WINDOWS\system32>set yyyymmdd=20110927
(null)
C:\WINDOWS\system32>copy \\10.6.206.88\d$\mssql\backup\css\CSS_db_201109271349.BAK D:\mssql\mssql\Restore\cssprod.bak
Access is denied.
(null)
Avatar of TempDBA
TempDBA
Flag of India image

there is a permission problem. Check for all the required permission for the a/c running job (job_owner) on the destination\remote folder.
ASKER CERTIFIED SOLUTION
Avatar of venk_r
venk_r
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial