Thank You Tim. I was able to figure out why it was not running. The batch ran fine when I scheduled it to run in task scheduler. ...

Thank you. This should help.

Yes, it is SP4. I am invesrtigating on getting AWE memory hotfix. I do not think we have that installed.

Thank you for your reply. SQL server version is 2000 SP4 There was a link at the bottom for 2000, and answer was to apply latest SP. ...