April 5, 2007 at 9:35 am
Hi - does anybody have any info on sp_verify_job. I cant find it in BOL!
Thanks
Allen
April 5, 2007 at 11:18 am
It must be a system proc. There's not only nothing BOL. There's nothing at MSDN. There's nothing at TechNet. There's precious little on a google search. What are you mucking with it for?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 10, 2007 at 2:11 am
Hi Grant, I have a 3rd party proc app that uses sp_add_job which I guiess calls sp_verify_job. 3rd party app fails on 2005 in sp_verify_job but works fine on SQL 2000. I think the way @notify_level_ ... works has changed
Allen
April 10, 2007 at 5:41 am
Ah, those wonderful 3rd party apps.
I really found next to nothing documented on that process. You may want to open a call with MS. I'd also contact the vendor and get them to start hopping through hoops too. If you find anything, please post it here in case others (probably using the same app as you) run into problems. I'd be curious.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply