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??

:mad: Y did they have 2 go and change it? :eek: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 :)|||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?

:eek:

Thanks again...|||I got it 2 wrk... I was write it was a mismatch in the log in details! :p

Thanks :)