-1

Every day and month i do same things which update and insert data on specific tables. the problem is that i m unable to use Agent for using scheduler Cuz of 'sa ' right. In this case, is there any other options exisited in ms sql? or Is it possible to link vb and sql for solving this problem ? plz comment any ideas and how will work thx

jarlh
  • 42,561
  • 8
  • 45
  • 63
j.lim
  • 3
  • 3

1 Answers1

1

One option would be to use windows scheduler. Create a scheduled task and run your queries either via sqlcmd or for example create a powershell script

Sqlcmd is probably easier, here is some info Executing a stored procedure using Windows task Scheduler you can also save your script into a file and run it via sqlcmd using [-i inputfile] command line argument

Community
  • 1
  • 1
shurik
  • 775
  • 9
  • 19