SQL Job with parameter

Posted by Skraghava under Sql Server on 3/21/2011 | Points: 10 | Views : 3294 | Status : [Member] | Replies : 3

Hi All,

Does anybody have sample code for a Job which takes parameter and runs on it?

Thanks and regards,
Raghavendra SK

Reply | Reply with Attachment

Posted by: PandianS on: 3/21/2011 [Member] [MVP] Silver | Points: 25

0	Hi Kindly explain little more about your requirements Cheers Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Skraghava, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Madhu.b.rokkam on: 3/21/2011 [Member] [MVP] Bronze | Points: 25

0	Usually SQL JOB doesn't take any parameters, but in Job Steps if you call an SSIS package that may take parameters for that you can use the DTEXEC command. Let us know your requirements clearly..to help you more on this. Thanks and Regards Madhu Skraghava, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: V-rajbog on: 3/23/2011 [Member] Starter | Points: 25

0	can you please Elaborate your requirement like is it for sql server query or do u want to call any SSIS package? Rajasekhar Boggarapu Skraghava, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts