SQL Server alerting

Here are some answers in order:
1. I would consider enabling standard alerts 823,824,825, and 16-25 as described here https://www.brentozar.com/blitz/configure-sql-server-alerts/ at least on any SQL production box. Aside that you could have custom alerts set for db files getting full, locking/blocking, long running SQL Jobs, PLE, High CPU, etc.

2.  You can run a SQL code like below to get all SQL Jobs info and there are lot more available free on the net if you search for particular details of each job:

use msdb
go

select 
	sj.name as JobName, 
	case when sj.enabled=1 then 'Yes' when sj.enabled=0 then 'No' end as JobEnabled, 
	sj.date_created as JobCreated, 
	sj.date_modified as JobModified,
	js.next_run_date as NextRunDate,
	js.next_run_time as NextRunTime,
	sc.name as ScheduleName,
	case when sc.enabled=1 then 'Yes' when sc.enabled=0 then 'No' end as Scheduled,
	case when sc.freq_type = 4 then 'Daily'
		when sc.freq_type = 8 then 'Weekly'
		when sc.freq_type = 16 then 'Monthly'
	end as Frequency
from dbo.sysjobs sj 
	inner join dbo.sysjobschedules js on sj.job_id=js.job_id
	inner join dbo.sysschedules sc on js.schedule_id=sc.schedule_id
-- where sj.enabled=1 -- uncomment this line to get only enabled jobs list
order by js.next_run_time;

Select all Open in new window

3. to find all enabled alerts you could run the code below which was originally posted here: http://www.sqlservercentral.com/scripts/msdb/110605/

--Run on source server
USE MSDB
GO

SELECT 'IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'''+NAME+'''))
 ---- Delete the alert with the same name.
  EXECUTE msdb.dbo.sp_delete_alert @name = N'''+name+''' 
BEGIN 
EXECUTE msdb.dbo.sp_add_alert @name = N'''+name+''', @message_id = '+CAST(message_id AS VARCHAR(10))+' , @severity = '+CAST(severity AS VARCHAR(10))+' , @enabled = 1, @delay_between_responses = '+CAST(delay_between_responses AS VARCHAR(10))+' , @include_event_description_in = '+CAST(include_event_description AS VARCHAR(10))+', @category_name = N''[Uncategorized]''
END
' FROM [msdb].[dbo].[sysalerts]
WHERE category_id <> 20;


--Add email notifications amend DBA to your operator
SELECT 'EXEC msdb.dbo.sp_add_notification @alert_name=N'''+NAME+''', @operator_name=N''DBA'', @notification_method = 7;'
FROM [msdb].[dbo].[sysalerts]
WHERE category_id <> 20;

Select all Open in new window