Thanks everyone for your input. After investigating more about the application and how it was set up, i found out that the database for the application was migrated from sql2000...

Thanks for the prompt response. According to the Job History both steps succeeded, not sure what is triggering the warning message.

Date5/19/2008 3:20:00 PM

LogJob History (OnePoint - TodayStatisticsUpdateComputersAndAlerts)

Step ID1

Servercomp02

Job NameOnePoint -...