We have a few jobs that run nightly that the status has to be reported every hour. I am trying to find in MSDB where I can capture the information below hourly and send out an excel file.
Server Job Order - Name NormalStartTime NormalEndTime ActualStartTime ActualEndTime Server A 1. JobA 11:00:00 PM 11:05:00 PM 11:00:00 PM 11:06:15 PM Server A 2. JobB 11:05:00 PM 11:15:00 PM 11:06:16 PM 11:31:09 PM Server A 3. JobC 11:15:00 PM 11:45:00 PM 11:31:09 PM 12:52:04 AM Server A 4. JobD 11:45:00 PM 11:50:00 PM 12:52:04 AM 12:53:08 AM Server A 5. JobE 11:50:00 PM 12:00:00 AM 12:53:09 AM 12:56:59 AM
Server = Server Name
Job Order - Name = This is the list of Jobs I want to search for. The 1-5 is not in the job name.
NormalStartTime = Earliest Start time
NormalEndTime = Latest End Time
ActualStartTime = The time the job started on today's run
ActualEndTime = The time the job finished today's run