J

(JOBID) token, 134

jobs, in SQL Server Agent

categories for, 107–108

configuring, 125–126

logging, 108

multiserver jobs, 138–141

notifications from, 108–109

operators notified when complete, 110–113

running

methods for, 106

in response to an alert, 117

scheduling, 109–110

token replacement for, 133–136

types of, 106–107

join algorithms

hash join, 463–464

merge join, 464–465

nested loop (loop join), 462–463