Schedule job to shutdown db on Windows 2000. [message #64413] |
Mon, 24 January 2005 06:14 |
Kelly Luo
Messages: 8 Registered: January 2005
|
Junior Member |
|
|
On our Windows 2000 production server, there is a scheduled job to automatically shutdown database each Sunday Morning. In the SchedlgU.Txt, usually I got message like the following:
"shutdown_DB.job" (shutdown_DB.bat)
Finished 10/23/2004 5:01:15 PM
Result: The task completed with an exit code of (0).
But this moring, when I checked the schedule job log, I found the following:
"shutdown_DB.job" (shutdown_DB.bat)
Started 1/22/2005 5:00:01 PM
"shutdown_DB.job" (shutdown_DB.bat)
Finished 1/22/2005 5:00:01 PM
Result: The task completed with an exit code of (1).
It seems to me that the shutdown_db.job didn't complete successfully. How can I find out what cause this happen and how to prevent this from happening again or if there are other better ways to realize such automatic job on Windows 2000? Thank you!
|
|
|