I'm using microsoft's type 4 jdbc driver to call a sp_add_job_schedule. The error below pop-up:
[SQLServer 2000 Driver for JDBC][SQLServer]The specified @name ('kkk') already exists.
funny thing is the job_schedule name kkk does not exist! Although after running this job, a new job schedule has been added, but I am still getting the error message above.
When calling sp_start_job, although the job executes successfully, I found out there are some errors in my log file
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]SQLServerAgent Error: Request to run job xxxx 2 (from User yyy) refused because the job already has a pending request from User yyy.