Team,

Is there any way to track the SQL end time.
I would like to automate in the script to track the SQL start time and end time.

We have adhoc query environment and needs SQL tracking.
Some SQL we have static which executes weekly, monthly -- We need to track the end time for these SQL.

We can capture start time by using list applications command.

Please help. If any one has script that capture SQL end time that will be helpful.

Thanks,

Do you want to capture the execution times of SQL statements or the duration SQL sessions (connections)?

I would probably do this in the application: take the current timestamp before the statement/session is initiated and take the current timestamp at the end. But I don't know exactly what you are after and which options you have in your environment.