Post reply

How to use script in script Library

  • September 16, 2005 at 4:25 am

    #363683

    Could anyone please explain how I can use script in script Library.  Can I use Query Analyzer to run or need to write program?  

  • September 20, 2005 at 12:47 pm

    #591467

    You can paste SQL scripts into QA and run them there.  Is that what you're asking ?

  • September 20, 2005 at 8:17 pm

    #591566

    Thanks homebrew01, that's my asking.

    BTW, for script that's need to do scheduling.  How we can store script in Server and schedule it to execute.

  • September 21, 2005 at 8:00 am

    #591774

    You can create a SQL job to be scheduled, then either paste the script into a job step, or build a stored procedure from your script, and execute the stored procedure from your job step. To create a job, use Enterprise Manager -> Management -> SQL ServerAgent -> Jobs.

    Then add the step, and schedule it from the Schedules tab. You can also use netsend or EMail to notify you if it fails, or succeeds

  • September 21, 2005 at 9:36 pm

    #592069

    Thanks. 

Viewing 5 posts - 1 through 5 (of 5 total)

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