January 28, 2010 at 1:01 am
Hi All
I am getting one error when running this Store procedure
exec master.dbo.xp_sqlagent_enum_jobs 0, testuser
from sql server 2005 management studio.
The error message is :
A severe error occured on current command. the result , if any , should be discarded
Windows Server - 64 bit 2008 Standard Edition
SQL Server - 64 bit 2005 Standard Edition with service pack 2
Could anybody help me to solve this problem
Thanks
Ghanshyam
January 28, 2010 at 6:50 am
This procedure takes 3 parameters, is_sysadmin, job_owner, and job_id. After some testing, it appears that you must be sysadmin to run this procedure without the job_id parameter.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 28, 2010 at 7:03 am
Thanks
Yes i was not having sysadmin right
Thanks
Ghanshyam
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply