Remove the [DBO] from the WHERE table_name = '[DBO].CUSTOMER'

Your IF NOT EXISTS should look like:

IF NOT EXISTS (SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'CUSTOMER'

AND COLUMN_NAME = 'CUSTOMER_ID')

ALTER TABLE [DBO].CUSTOMER ADD CUSTOMER_ID...

Not sure what causes the "Date and Time Not Available", but a simple Re-Boot of the server corrects the problem

I have checked the sysjobschedules and the next run date is there, but when I run sp_help_job the next run date does not show.  I have also checked the targetserverrole...