I have created a DTS package and scheduled a job ofr it.
I then used sp_start_job on the Query Analyzer to start the job. The message indicates that the job has started successfully.
I then checked the job histoy and found the following errors
Step ID 0
The job failed. The Job was invoked by User <NAME>\<my user name>. The last step to run was step 1
Step ID 1
Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed.
I have public access to msdb database.Am I missing anything else?