SQL Jobs

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
This topic is 3 years and 11 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
Reddrgn2
Posts: 49
Last visit: Wed Nov 08, 2023 10:34 am
Answers: 1

SQL Jobs

Post 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?
User avatar
mxtrinidad
Posts: 399
Last visit: Tue May 16, 2023 6:52 am

Re: SQL Jobs

Post 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.

:)
User avatar
Reddrgn2
Posts: 49
Last visit: Wed Nov 08, 2023 10:34 am
Answers: 1

Re: SQL Jobs

Post 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
This topic is 3 years and 11 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.