January 29, 2009 at 9:41 pm
hello and thanks for the time and assistance...
I have just started with SQL 2008 and running into a situation that is not complicated i am sure but nevertheless i cant seem to figure it out...its simply my lack of sql 2008 knowledge. anyways..thts why i come here 🙂
trying to run this
exec sp_cmdshell 'perl script.pl in the ticks'
now this has worked on all other versions from 7 up to sql 2k5 yet now its not working like i need it too. if i run it at the DOS prompt ..runs like a champ. is this something to do with "power shell" and if so what do i need to do to make this work in SQL 2k8 any slight bit of help appreciated. Thanks
-Darryl
DHeath
January 30, 2009 at 6:53 am
I assume you mean:
exec xp_cmdshell 'perl script.pl in the ticks'
What error are you getting? Is xp_cmdshell enabled? Do you have the appropriate permissions or proxy configured?
January 30, 2009 at 7:24 am
is it xp_cmdshell enabled(???)... permissions(sysadmin) .... and i hope this answers the questions you asked. I do know that if i run the command directly in QA it gives me out put in a lower screen, but if i pass it thru a job all seems to complete with "successful" but i dont get any results that i am expecting.
If i run the commands at a DOS prompt "perl script here.pl" all seems to run well at that point to.
I am sorry but i know its my lack of knowledge with 2008 🙁
DHeath
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply