Page 1 of 1

SQL Jobs

Posted: Wed Apr 08, 2020 7:13 am
by Reddrgn2
Product, version and build:
64 bit version 4.5.71
Operating system:
64 bit OS: win 10 enterprise

I am trying to see if there is a way to connect to a SQL and view its jobs?

Re: SQL Jobs

Posted: Wed Apr 08, 2020 8:28 am
by mxtrinidad
You need to create a connection to the SQL Server MSDB table, then you'll have access to the sysjobs objects: tables, procedures, views, and more.
Keep in mind, that you'll probably need to have some level of authentication to access the MSDB system table.

:)

Re: SQL Jobs

Posted: Wed Apr 08, 2020 9:43 am
by Reddrgn2
I think I got it now, thanks. After connecting to MSDB I needed to run 'exec dbo.sp_help_job' to get the list of jobs and the details. Thanks