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: 246960 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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

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: 323518 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!