I have been running by sql backup jobs using a script which was added to a sql job and schdueld to run, i have seen that many times jobs either failed with error not backing up all databases or it doesnt backup all db's without giving any failure errors and so i have to manually backup few databases which was pain BUT when i created a maiantenance plan using the same script, the job runs successfully backing all db's.
I am trying to understand the difference between these 2 ways of executing a job, any idea?