I have a vb script which moves files from one server to another and it works successfully when run manually but when a job is created in SQL Agent to automate the process it doesn't perform the task. SQL Agent doesn't fail it simply does not perform the move.
我有一个vb脚本,可以将文件从一个服务器移动到另一个服务器,并且在手动运行时可以成功运行,但是当在SQL代理中创建作业以自动执行该过程时,它不会执行任务。 SQL代理不会失败它只是不执行移动。
I granted local admin rights to the account performing the task and still nothing. I copied the files manually to the local SQL Server but I still get the same outcome when attempting to run the job in SQL Agent.
我授予执行任务的帐户的本地管理员权限,但仍然没有。我手动将文件复制到本地SQL Server,但尝试在SQL Agent中运行作业时仍然得到相同的结果。
I also tried using FQDN but it still doesn't perform the process. Any suggestions? Please help and thanks in advance.
我也尝试使用FQDN,但它仍然没有执行该过程。有什么建议么?请提前帮助和感谢。
2 个解决方案
#1
2
if you have 32 bit try:
如果你有32位尝试:
C:\Windows\system32\config\systemprofile\Desktop
For the package to work. If you do not have Destop folder, create one and it should work.
为了工作包。如果您没有Destop文件夹,请创建一个,它应该可以工作。
#2
1
Try to check: C:\Windows\SysWOW64\config\systemprofile\Desktop folder for the package to work.
尝试检查:C:\ Windows \ SysWOW64 \ config \ systemprofile \ Desktop文件夹以使程序包正常工作。
#1
2
if you have 32 bit try:
如果你有32位尝试:
C:\Windows\system32\config\systemprofile\Desktop
For the package to work. If you do not have Destop folder, create one and it should work.
为了工作包。如果您没有Destop文件夹,请创建一个,它应该可以工作。
#2
1
Try to check: C:\Windows\SysWOW64\config\systemprofile\Desktop folder for the package to work.
尝试检查:C:\ Windows \ SysWOW64 \ config \ systemprofile \ Desktop文件夹以使程序包正常工作。