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

    Unanswered: Scheduling stored proc.

    How do you schedule stored procedures? I can see no way of linking them to the job scheduler.

    Also, how do I time the stored proc. schedule to activate after a scheduled DTS package?

    Thanks again guys!
    Last edited by achowe; 07-03-03 at 05:06.
    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
    Jul 2003
    Posts
    45

    Re: Scheduling stored proc.

    OK, I see how to schedule a stored proc...by just scheduling an execute command.

    But I still cant see how to time this with the scheduling of a DTS package.
    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!

  3. #3
    Join Date
    Jan 2003
    Posts
    26
    You create a new DTS.
    You drop your connection,
    You drop "Execute SQL TASK". You write your SQL-query

    (example: "exec myproc")

    you choose "save as" and name your DTS.
    Now you will have a DTS in the list, and you right click on it and choose "Scedule Package"


    Good luck!

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Its possible to execute and schedule a stored procedure using job scheduler just mention SP name and select connected database, schedule it.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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