I'm using Automation Engine version 11.2 with Java console interface.
By default when the job fails, we will check the "report" and then we can see several log files. But with SQL-typed job, the report does not help. It just shows: "Changed databsae context to [database_name]" and we are not able to check and identify the problem.
Are there any ways/methods to enable the log/report for SQL jobs? Or we have to search and look at the raw log files? Or something like that?
Need to solve the problem of this failed jobs and without log, there is no hint to troubleshoot.