Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inibhreaslain
Starting Member
19 Posts |
 Posted - 2009-03-30 : 15:03:14
|
| I have a trigger on a table that works as expcted. It calls a job.Another team in our company have created an applicaiton that calls a stored procedure I created. This stored procedure enters data into the table with the trigger. When I call the stored procedure through Management Studio, the trigger gets fired, and the job is executed. When their application calls the stored procedure, it enters data everywhere it should (including the trigger table), but the job is not executed and they get the error message:System.Data.SqlClient.SqlException: The specified @job_name ('JobXYZ') does not exist.Is this a permission issue? If so where? I have looked at the Job log and there is no record of an attempted execution which I would have thought would be the case if it was a permission issue? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
inibhreaslain
Starting Member
19 Posts |
Posted - 2009-03-30 : 16:42:18
|
| Thanks. I'm pretty sure it is a permission issue. |
 |
|
|
|
|
|
Application--->Stored Procedure--->Trigger-->Job