sql agent jobs.

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
Who is Participating?
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
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:
FROM msdb.dbo.sysjobs j
    INNER JOIN msdb.dbo.sysjobhistory h ON j.job_id = h.job_id

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.