Stored Procedure & Jobs

[davedavolt]

I have a 3rd party application that only looks to it's SQL database for SPs. I need that application to run a stored procedure. That stored procedure calls a job, used sp_start_job. The job is a DTS package. The package and job work. When the SP is created in the msdb database, it works. Created the SP in the 3rd party SQL DB, and copied the sp_start_job and sp_verify_job_identifiers to the 3rd party DB. The SP I created works from QA in the msdb and 3rd pary DB, but when my application runs the SP, I get the following error:
ccserver 650 ERROR Message from SQL-Server: The specified @job_name ('myjob') does not exist.

It also refers to error 14262.

If you look at sp_start_job, you'll see that is calls error
14262 for two different error conditions. I am going to try and figure why the error 14262 is called, but am not that great at SQL code yet.

 

[davedavolt]

Note: It has something to do with logins. I have been logged in and connected to SQL with my account(administrator).

The 3rd party app is given permissions to run the SPs.

When I connected to QA as the 3rd party account, I got the 14262 error.

Still looking at what permissions are needed to get this to work.