Manage SQL Server Agent

Question 1

How do you see what jobs are running and what the finished status was of ones that have completed?

Answer 1

Job Activity Monitor

Question 2

What is the system table to get Job Information?

Answer 2

use [msdb]
go
SELECT * FROM SYSJOBS

Question 3

What system table is used for the Job Setup (Including actions that it will take?)

Answer 3

SYSJOBSTEPS

USE [MSDB]
GO
SELECT * FROM SYSJOBSTEPS

Question 4

What system table is used to see information about job time run from beginning to end?

Answer 4

SYSSESSIONS
SYSJOBACTIVITY
SYSJOBHISTORY

Question 5

What is the system table that shows the schedules and types?

Answer 5

SYSSCHEDULES

Question 6

What is the syntax for RAISERROR?

Answer 6

RAISERROR(ID, SEVERITY, STATE) –STATE = 1 usually

For custom errors, you need to add a line to sys.messages using EXEC sp_addmessage

Question 7

How do you get an alert to run when RAISERROR has happened?

Answer 7

Use WITH LOG in the RAISERROR command:

RAISERROR(50001, 16, 1) WITH LOG

Question 8

What are the steps to be able to send an email from an alert or job?

Answer 8

Configure database mail from Management->Database Mail
Create a new Operator (Agent->Operators->New Operator)
Go into the alerts or jobs and set the operator as a receiver of emails