Nice to have creation date in BATCH_JOB_INSTANCE table
I feel it would be good to have a creation date in BATCH_JOB_INSTANCE table. We are actually trying to figure out the schedule date based on the job instance creation date to generate reports. One of the alternatives is to have schedule date as a parameter. But i want to maintain the uniqueness of the job instance by the file name which is being sent as an input parameter. If i send the schedule date(Systems date) as a parameter it would defeat my purpose since the job could be restarted the next day also in case it fails.
So i feel it is good to have a creation date in the BATCH_JOB_INSTANCE table which would help us to identify the job instance that was created on that day and help us to extract a report for that day.