What defines the start and end dates of a transaction?

Do you store that data anywhere else in the database?

What are you actually trying to accomplish here as the question is...

So you are only backing up the log once a day, well that is really no use.  Again it is time to push for RTO / RPO as that is...

First of all are you doing log backups for the DB?

If not speak to your team and ask them, "hey what is the RTO and RPO for this database" and...

What would you usually be creating a maintenance plan to do?

DBCC CHECKDB

Database backups

Index maintenance

So doing a quick google search (other providers available) “do I need to run dbcc checkdb on...

Have you verified that “NT Service\MSSQLSERVER” has full control to the root folder of the mdf files with the needed inheritance enabled downstream?

Just want to verify you are on SQL 2012 and not SQL 2008?

Should 10.0.2100 actually be 11.0.2100?

Major version 10 is SQL 2008 so wont go to 2019 without an intermediary...

Add a waitfor delay line/step to the job to wait 2 hours after the start, and before the stop

ALTER XE START

WAITFOR DELAY '2:00:00'

ALTER XE STOP

https://www.brentozar.com/archive/2023/01/announcing-the-2023-data-professional-salary-survey-results/

Best bet is to speak to your Microsoft partner / reseller who sold you the license, or is now in charge of your licenses.  Either that or subscribe to Visual...

sys.dm_tran_active_transactions

Should give you most of what you need here, the name will be "implicit_transaction" for implicit, the state will have 4 for a distributed transaction, etc.

Probably one to go and read the documentation on how to use Informatica, but looks like you don't use the ' on the value in the where

https://docs.informatica.com/data-quality-and-governance/informatica-data-quality/10-4-0/application-service-guide/data-integration-service-rest-api/queries/where-clause.html

Hope this is the...

SQL Server is not a front end piece of software and will not prompt a user for an input.

If you want to get a user to pass values, you need...

Please script and paste the whole procedure so everyone can see what is failing as you have multiple issues on multiple lines.

On that same properties area is the "Size of job log" and "number of rows per job".

Are these set at the default 1000 / 100?

How many jobs do you have? ...

Treat it like a CU.

A GDR fixes CVEs with the product.

You plan and prepare for installing it the same way in which you would a CU, the installation process is...