List all SQL jobs in Job Activity Monitor with Sp_help_job

Question: How can I list all jobs that appear in the SQL Server Agent Job Activity Monitor?

Answer: To list all SQL jobs as listed in the Job Activity Monitor use the msdb.dbo.sp_help_job stored procedure.

Using msdb.dbo.sp_help_job

The stored procedure accepts parameters, and if you’d like to view the parameters link here. Otherwise running the stored procedure   - msdb.dbo.sp_help_job -   without any parameters will list all the jobs  and associated details - such as status, name,description,owner_sid,date_created,date_modified,enabled

Another option is   msdb.dbo.sysjobs_view

USE msdb ;
GO
EXEC dbo.sp_help_job ;
GO

Read More on SQL Server Agent job history

SQL Server - Send sql server agent job history through email notification

SQL Server agent fixed roles

SQL Agent Jobs – Schedule in seconds

List failed SQL server Jobs with Powershell