• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • Last Modified:

Schedule Stored procedure in windows scheduler

How to schedule sql stored procedure in the windows scheduler.
0
sharmiladhakshnamoorthy
Asked:
sharmiladhakshnamoorthy
  • 2
1 Solution
 
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
 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now