>I'm trying to access the sp_help_job procedure and it is driving me nuts. I am using the code below. If I comment out all of the parmeer stuff it works fine and retrieves me all of the information. But if I try to specify the job_id or job_name (only one may be sent to the sp) my recordset comes up empty. I am not receiving any errors either. I know it can see the the right records because if I mis-spell ResetTrainingLogonAttempts when calling job_name (and issue a null to job_id even though I shouldn't have to!) it tells me the job name does not exist. I've been busting my head for 4 hours on this irritating thing. Help! Please!
>

Whenever in doubt, the refreshed parameters collection you should check out. <g>

Just call Parameters.Refresh, loop through and print the definition of each parameter at development time so that you create and populate the correct collection at runtime.