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.
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 to use the mdsb view – msdb.dbo.sysjobs_view
USE msdb ; GO EXEC dbo.sp_help_job ; GO