In our project, we have two SQL Server Jobs- one to run on every night 12 AM (let’s call it “JobA”) and another one to run on every month ( 1st of every month 12AM. And let’s call it “JobB”). These job creation scripts were run on April 8.
We have a log table that logs each successful run of the jobs (It logs failures happened during execution also). When I checked the log it is found that the “JobA” has run successfully from April 9 to April 30. Then it has run May 3rd to till date. And there is no log for “JobB”
I am assuming that the server would have gone down on May 1st and May 2nd, that’s why I don’t see any log for “JobB” in our logging database.
However, how do I prove it?
- Can I use any properties from the job to prove this?
- Can I use any server logs to prove it?
Please share your thoughts.