If a scheduled job created from a template fails to run, check the job history for error messages. If a job failed to run, the reason why will be reported in the job history.
If you have not installed the stored procedures used by the templates on the target server where your job will run, you will see an error message similar to the following:
Procedure 'dump_databases' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
See “Installing stored procedures on a target server” for more information.
