Hi Jack,

Thanks for your reply. percent_complete in sys.dm_exec_requests does not show for CREATE INDEX. The job got completed.

I took a different approach to monitor. I checked sp_helpindex to check how many indexes got created.

But I am still wondering what that Insert command was doing while creating indexes.

Thanks,

Dev