[SQL Server] SQL Agent tokens problem |
| Posted: 23 Jun 2013 11:55 AM PDT I am trying to use SQL Agent tokens to specify the output file name within a SQL Agent job, for example:F:\SQLLogs\Daily_Batch_$(ESCAPE_SQUOTE(STRTDT))_$(ESCAPE_SQUOTE(STRTTM)).logHowever the STRTTM and TIME tokens are not producing HHMMSS output as expected, the hour component has leading zeros omitted.Does anyone know of a way to configure this? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server Newbies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment