Issue : one job which runs for every 5 minutes failed today (completed successfully yesterday) with error one of the object database.dbo.Table was not found.

The database was not found on the server. Immediately Application team created the DB to resolve the issue and then the job started succeeding

I am troubleshooting the reason

Checks:

1.Checked the server log and error log both current and archived .No information was available expect the latest create database

2.I checked the job modified date and created date both are of last month

3.I checked the SP which is running under this job. The last modified date of this SP is also last month

4.daily running maintenance jobs are not considering this database(found this in the log file of maintenance job)

5.Checked for any hardware failures, some other databases were also existing on the same drive and no issues with these

6.No related errors in the event viewer too

I thought the database was never existed ,then how come the job completed successfully yesterday?

Am I missing something else?