All SQL JOBS Status

Question

All SQL JOBS Status

Sangeeth Raj

Hall of Fame

Points: 3541
More actions
November 15, 2016 at 9:12 am

#322996

Hi,
I am not into DBA, but I got a task to create view/table to display all the jobs live status to display to Non Technical Team. Could any one provide what would be my starting point.
Many Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

Sangeeth878787 (11/15/2016)
Hi,
I am not into DBA, but I got a task to create view/table to display all the jobs live status to display to Non Technical Team. Could any one provide what would be my starting point.
Many Thanks

All job stuff lives in msdb and you have full access to read the tables. Look at sysjob... tables there.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Phil Parkin SSC Guru Points: 245813 More actions · Answer 2

Sangeeth878787 (11/15/2016)
Hi,
I am not into DBA, but I got a task to create view/table to display all the jobs live status to display to Non Technical Team. Could any one provide what would be my starting point.
Many Thanks

If this is just a one-off requirement, try clicking on the Job Activity Monitor node in SSMS, under the SQL Server Agent node.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Sangeeth Raj Hall of Fame Points: 3541 More actions · Answer 3

HI Phil,

I am glad for your reply, this is not off requirement, we are going arrange Sql Job status monitor report in TV, where everyone can see what report is running and what report is going to be execute in soon.I need to create a template or view for live Job Status Reports.

Lowell SSC Guru Points: 323482 More actions · Answer 4

since this is more of an in your face dashboard, you'll need to build the pieces, failed jobs vs next scheduled jobs.

this site has a nice query for the next jobs that are scheduled:

http://blog.sqlauthority.com/2008/12/22/sql-server-find-next-running-time-of-scheduled-job-using-t-sql/

this site has four or five deep examples for querying various parts of jobs information:

https://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/

so those would be the building blocks i would suggest starting with; i'm thinking you wanted to put the results in an SSRS report or something, is that what you are planning?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!