Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Posts
    45

    Unanswered: Automated procedures help

    Anyone any tips for the most efficient way to automate procedures/sequence of queries in SQL server 2000?
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Set up a SQL Server Job through Enterprise Manager's SQL Server Agent.

    blindman

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    automate procedures and quries into stored procedures.

    if you wish to schedule these tasks you can setup jobs to execute stored procedures or TSQL commnds or both.
    Paul Young
    (Knowledge is power! Get some!)

  4. #4
    Join Date
    Jul 2003
    Posts
    45

    triggers........

    could triggers not be the answer..........?
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Triggers are used when you want some event to occur every time data in a table is inserted, deleted, or modified.

    For nightly batch processing, which is what I thought you were getting at, scheduled jobs are the most convenient method.

    What kind of task are you trying to automate?

    blindman

  6. #6
    Join Date
    Jul 2003
    Posts
    45
    Basically, I have a table ( or many tables) which are going to be updated several times a week, after which some queries will be run....................just need to automate this process........
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  7. #7
    Join Date
    Jul 2003
    Posts
    45
    Actually..I think using schduled jobs and sprocs is my answer...do you tend to agree?
    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Absolutely.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •