Set up an automation script and it runs successfully inside Toad. However, when the task is scheduled, it fails with 'ORA-01005: null password given; logon denied'
原因
Password was not saved in the connection manager. This is required when scheduling a job to run
解决办法
In the Connection Manager | Right Click the connection | check 'save password' | reconnect to the database.