Home Forums SQL Server 2008 SQL Server 2008 - General Date in BCP out file name RE: Date in BCP out file name
PhilPacha
Hall of Fame
Points: 3645
More actions
February 21, 2013 at 3:30 pm
#1590155
Since you are running a SQL Server Agent job, you can use SQL Server Agent tokens.
The one for date the Job started running is: $(ESCAPE_NONE(STRTDT))
Here's a link to the 2008R2 help...
http://msdn.microsoft.com/en-us/library/ms175575.aspx