Solved

sql  agent jobs.

Posted on 2016-10-19
2
28 Views
Last Modified: 2016-11-03
I have a sql server that has a partition (partition houses the ldf and mdf's only) that sets off alerts during the night.   the alert is low disk space.  it gets down to about 1 gig of free space at around 1:30 am.    When i come in, in the morning, the same partition has about 10 gigs of free space.

There are a lot of jobs in the sql server agent section of ssms.  I was wondering if there was a way for me to see all the start times for these jobs and tell which one might be using up all the disk space during the middle of the night without me digging into every job.  

If someone thinks i am going down the wrong trail... please advise.  if someone knows a query that will show me all sql jobs and what times they start.... that would be great.  i do have maintenance plans but they fire off 4 hours after i get the notification of low disk space so I don't think its a maintenance plan.

thanks everyone
0
Comment
Question by:jamesmetcalf74
2 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 500 total points
Comment Utility
SQL Agent jobs information are stored in msdb.
Check for dbo.sysjobs and dbo.sysjobhistory. A join between these two tables should give you some information:
SELECT *
FROM msdb.dbo.sysjobs j
    INNER JOIN msdb.dbo.sysjobhistory h ON j.job_id = h.job_id

Open in new window

0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now