After configuring Log Shipping, the first job that runs is the transaction log backup. However, it keeps on failing with very generic error:
Executed as user: DOMAIN\sqlagent1. The step failed.
No matter what you do, it just won’t log anything else, e.g., configuring the Job step to log to file just ends up with empty log file. Also the log table contains no rows for this specific step.
I finally tried executing the sqllogship.exe command from the failing Job step on the SQL server:
"s:\Program Files\Microsoft SQL Server\130\Tools\Binn\sqllogship.exe" –Backup <GUID> -server SQL-1
and it displayed me dialog that .NET Framework 3.5 was required on the server. After installing that from “Add Roles and Features”, the Job finally executed without issues.