Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. Lightweight jobs have the following characteristics: Unlike regular jobs, they are not schema objects. They have a significant improvement in create and drop time over regular jobs because they do not…