SQL Agent tokens problem

• Shaun.ODell-1127859

  SSC Veteran

  Points: 287

  More actions

  June 23, 2013 at 6:55 pm

  #395018

  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)).log

  However 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?

• Leonard Rutkowski

  SSCrazy

  Points: 2668

  More actions

  June 27, 2013 at 1:02 pm

  #1628099

  is this what you are looking for:

  msdb.dbo.agent_datetime($(ESCAPE_SQUOTE(STRTDT)), $(ESCAPE_SQUOTE(STRTTM)))