sql agent jobs.
Posted on 2016-10-19
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.