Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    76

    Unanswered: schedule stor proc in 2005

    Hello

    I KNEW this would cause some problems, but I just can't seem to find how to do it....

    Basically I have a stored procedure in 2005 dbase (which updates the data), and I want to schedule it to run daily (at night) HOW CAN I DO THIS????

    Y did they have 2 go and change it???

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    This hasn't actually changed in any substance since 2000 so I guess there is more to it than this....

    Schedule it as a job
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2005
    Posts
    76
    Thansk for replyin 2 such a dumb question... I was looking for a similar MAnagement thing...n didnt actully look under the agent....

    I am still having a problem, basically the stored procedure inserts data from a linked server...and when I run it, it works successfully. BUT when scheduled to run (ie being run by the system) I get a user login failure... what do I need to do to get it 2 wrk???



    Thanks again....

  4. #4
    Join Date
    Feb 2005
    Posts
    76
    I got it 2 wrk.... I was write it was a mismatch in the log in details!

    Thanks

Posting Permissions

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