SQL Job with parameter

Posted by Skraghava under Sql Server on 3/21/2011 | Points: 10 | Views : 2071 | 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



Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response