How to enable Always Encryption in SQL Server Agent Jobs

• SQLisAwe5oMe

  SSChampion

  Points: 14052

  More actions

  October 20, 2023 at 9:48 pm

  #4312071

  I am trying to run a SQL Agent job to select an encrypted column, but it's still shows as encrypted. How can I run SQL agent job to run with Always Encryption enabled.

  Regards,
  SQLisAwe5oMe.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 21, 2023 at 10:10 pm

  #4312598

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Emperor100

  SSCrazy

  Points: 2221

  More actions

  October 24, 2023 at 9:39 pm

  #4314199

  Hi,

  Are you trying to run a DTSX package with encrypted column, If not can you elaborate your question?

  =======================================================================