Solved

sql  agent jobs.

Posted on 2016-10-19
2
60 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41850227
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

705 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