declare @xp_command varchar(8000) declare @directory varchar(8) declare @path varchar(1000) declare @month varchar(2) declare @day varchar(2) declare @year varchar(4) set @month = Right('00' + convert(varchar(2),DatePart(m,getdate())),2) set @day = right('00' + convert(varchar(2),DatePart(d,getdate())),2) set @year = convert(varchar(4),DatePart(yyyy,getdate())) set @directory = @month + @day + @year print @directory set @xp_command = 'mkdir d:\FOM\FOM_Job_Logs\Archive\' + @directory print @xp_command exec master..xp_cmdshell @xp_command set @xp_command = 'move d:\FOM\FOM_Job_Logs\*.* d:\FOM\FOM_Job_Logs\Archive\' + @directory print @xp_command exec master..xp_cmdshell @xp_command