When exists(

Select case when [enabled]=1 then [name] + ' Enabled' else [name] + ' Not Enabled' End

)

Please do not use C:\Program Files\Microsoft SQL Server\100\DTS\Packages

If you have to use C drive, create C\:DBA\SSIS folder and give sql server agent permission to it

Perhaps you are looking for change data capture?

I would apply the TDE certificate first and restore it on the destination first.

You can set the up the destination database in standby mode and create a job on the...

Sounds like you need to create a datetime column for date1 + time1 , then date2 + time2

After this do a a simple datediff for minute

Can you tell us more about what you want to do?

You could run a poweshell script to read the file names in the folder tons sql table and then run...

There is one blog post with instructions on wmi alert

https://www.sqlshack.com/create-configure-sql-server-agent-alerts/

Does column HCPCS_CPT exist? In your where clause, replace this with the definition you used to calculate it

I think a wmi event would work. A sql server agent wmi alert when a file is downloaded and then calls a sql server agent job.

So you have at least 2 nodes and an AG with an asynch secondary on a different subnet.

Your listener has more than 1 ip. You need to set hostrecordTtl to...

Can you add a sql server agent operator?

Then  set the job notification to that operator

Unusual decision by the security team. You are going them all your data and a tde certificate would protect the backup in transit, but security is worried about a certificate?

Could...

Perhaps you should make the database full recovery.

You can schedule regular transaction log backups to limit growth.

Is the transaction log and data file set to grow by a percentage? If...

My apologies

Below is the link that fixed the issue for me

https://docs.microsoft.com/en-us/archive/blogs/docast/ssis-package-execution-failure-when-ssisdb-is-configured-with-alwayson

I had same issue

Use Ssisdb

Go

Open master key decryption by password 'xxx'

Alter master key add encryption by service master key

https://blogs.msdn.microsoft.com/docast/2015/08/21/ssis-package-execution-failure-when-ssisdb-is-configured-with-always-on

Let me know if you still have an issue