This question already has an answer here:
- MAXDOP setting algorithm for SQL Server 8 answers
How we can determine how much time a job takes to execute in sql server, I have a job which runs every hour, I also having some performance issue so I wanted to check if the performance issue is because the job is running or something else and that is why I have to check how much time job is taking to finish.
Job is basically to update the table.
Any help or tips will be very helpful!!!!!