Job issue almost working

Job issue almost working

 

  

I have set up a job to transfer file





declare @BackupName varchar(200)

Set @BackupName = 'xp_cmdshell'+"'"+'copy' + ' "e:\Microsoft sql
server\MSSQL\Backup\' +'Mydb_' + CONVERT(varchar(8), GETDATE(), 112) +
'2100' + '.BAK"'+

'"\\10.10.10.10\backup\"'+ "'"+ ',no_output'

print @backupName





IT prints the command as I want; but when I do



declare @BackupName varchar(200)

Set @BackupName = 'xp_cmdshell'+"'"+'copy' + ' "e:\Microsoft sql
server\MSSQL\Backup\' +'Mydb_' + CONVERT(varchar(8), GETDATE(), 112) +
'2100' + '.BAK"'+

'"\\10.10.10.10\backup\"'+ "'"+ ',no_output'



@Backup





Give me syntax error what I am doing wrong




MS Sql Server LazyDBA home page