Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it Possible to create a job in osql?

Status
Not open for further replies.

jemma

Programmer
Aug 10, 2004
1
GB
Just wondering if it is possible to create a job in osql? I know how to create a job in Enterprise manager but was wondering if anyone knew how to create one in either isql or osql command utility. This create i want to create would need to be scheduled for a certain time.

Any help would be appreciated,

Thank you,

Jemma
 
Hello Jemma,
Yes, you can create a job in sql by using sp_addtask. Please see Books On Line for its parameters.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top