Monitor the active session scheduled by SQL agent service

It is very common  that you should investigate what is going on the server at a certain time and you can not find any scheduled job. Yes, the application run a big job. If you want to see current processes, you can run:

If you want to log it, you can schedule for every 1-10 minutes (you have to set the @destination_table and @destination_database, and the table will be created at the first running time):

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *