Schedule Stored procedure in windows scheduler

How to schedule sql stored procedure in the windows scheduler.
sharmiladhakshnamoorthyAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>i dont have access to that server, thats y i want to schedule in windows
but you have access to that server's windows scheduler?

anyhow, check out the sqlcmd command line tool that can connect to sql server and run a .sql file.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
why do you want to use the windows scheduler, sql server comes with sql agent jobs that can be scheduled very easily...
0
 
sharmiladhakshnamoorthyAuthor Commented:
i dont have access to that server, thats y i want to schedule in windows.That server is owned by different group, so im not allowed to created any job schedule and run it.
I want to know how to write code in .sql file and schedule it in windows scheduler.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.