I can provide this details after some time.

I do have one doubt to clarify. We have a report subscribed for one time run but when I check the subscriptions the status is showing pending.

What does it mean by pending from 2 days.

Is that report run is completed and just sending the mail is pending?

Usually report time we can divide into 3 parts right.

Data retrieval + Report Processing + Report rendering.

How to find in which status it is pending? The email is correct only. The another reports are sending fine to that email

I run the trace, I can see that login and sproc but the login is using to execute several reports and also might be the same stored procedure will use in 2-3 reports also right.

How can I confirm that this report is still running that is the reason the status is still pending?

Any help would be appreciate