Post reply

scheduling sql script

  • May 27, 2003 at 1:50 pm

    #80987

    I have a sql script(1.sql) which saved in my folder(c:\...\..).I wanted to run this script daily at 12:00 am.Is it possible to do this by saving in to my folder.If possible how to do that.If not where should i save the file.

    Please help me in this issue.

    Thanks in advance

  • May 27, 2003 at 2:11 pm

    #458725

    Create a job, copy and paste your script into job step and schedule the job to run at time you like.

  • May 27, 2003 at 5:54 pm

    #458747

    Agree with Allen_Cui.

    Otherwise if you insist you'll have go the 'xp_cmd / osql' route.

    Do no think its worth even considering under normal situations.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply