I have a rebuild index job that is set to run every night. The job used to run fine, but last night for some reason the SQL Server Agent Job was stopped. The rebuild index job was running on 9 different databases and it used to take less than 2 minutes, but it stopped all of a sudden last night with an error in the last step.
Here is error message:
The job was stopped prior to completion by User [User_name]. The job was invoked by Schedule 37 (daily).
Executed as User: User-Name. The step was cancelled (stopped) as the result of a stop job request.
I checked on SQL Server logs, there are no error messages. Where can I find exact root cause of job stopped?