Groups | Blog | Home
all groups > sql server mseq > october 2003 >

sql server mseq : Trigger


Charles
10/22/2003 2:03:24 PM
I have an INSERT trigger set up on a table and when i
manually run an INSERT from Query Analyzer, it works as
designed, but when running from the application
(peoplesoft), the error generated is:

SQL Status = 22022, SQL Error = [Microsoft][ODBC SQL
Server Driver][SQL Server]SQLServerAgent Error: Request to
run job Ecqueue_Errors (from User
WORLDCLASS\Administrator) refused because the job already
has a pending request
from User WORLDCLASS\Administrator.
Ray Higdon
10/22/2003 6:32:41 PM
Can you post your trigger code and DDL?

--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]

AddThis Social Bookmark Button