Scheduling SQL Scripts Using Jenkins

• VishnuGupthanSQLPowershellDBA

  Ten Centuries

  Points: 1230

  More actions

  December 22, 2020 at 12:00 am

  #3817953

  Comments posted to this topic are about the item Scheduling SQL Scripts Using Jenkins

  Vishnu Gupthan
  PowershellAcademy
  www.powershellacademy.com

• JediSQL

  SSCrazy

  Points: 2119

  More actions

  December 22, 2020 at 6:32 pm

  #3823269

  It looks like something weird happened when copying and pasting the "SQL script to initiate a backup of a database."

  SELECT @MyFileName='C:\PS\SQLScript\Backup\' + REPLACE(cast(cast(convert(nvarchar(20) as nvarchar(max)) as nvarchar(max)),cast(cast(GetDate() as nvarchar(max)) as nvarchar(max)),cast(cast(120 as nvarchar(max as nvarchar(max))))),':','-') + '.bak'
  

  This portion does not even make sense:

  cast(cast(convert(nvarchar(20) as nvarchar(max)) as nvarchar(max))

  It looks like the code got over-processed by something after starting out something like this:

  SELECT @MyFileName = N'C:\PS\SQLScript\Backup\' + REPLACE(CONVERT(nvarchar(max), GETDATE(), 120), N':', N'-')+ '.bak';

   

  • This reply was modified 4 years, 3 months ago by  JediSQL.

  Sincerely,
  Daniel