“Scheduling” An E-Mail For A Long-Running Job

Here's the scenario:  you have a SQL Server Agent job which is currently running and you want to know when it completes.  You can use Adam Machanic's sp_whoisactive (or a less civilized alternative, but honestly, who wantst that?) and hit F5 like a monkey on crack until you see the SPID running this job ends.  Or you could do…

Advertisement