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\datepar ts.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\bac kup\css\CS S_db_20110 9271349.BA K D:\mssql\mssql\Restore\css prod.bak
Access is denied.
(null)
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\datepar
(null)
C:\WINDOWS\system32>for /F "tokens=1 delims=" %a in ('cscript //nologo "C:\WINDOWS\TEMP\dateparts
(null)
C:\WINDOWS\system32>set yyyymmdd=20110927
(null)
C:\WINDOWS\system32>copy \\10.6.206.88\d$\mssql\bac
Access is denied.
(null)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.