Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how i can launch automatically 30 querys in db sqlserver 6.5

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I have a database sql server 6.5 and i need same statestics evry day then i need lunching same query(SQL requests) but the systeme very slow
So i want to excut this request in the of time like 2:00PM
But i don't know how i can lunch automatically these querys may be 30 qeury.
I will be apreciat if any one help me
Thanks a lot
med

 
Is the answer to this as simple as setting up a stored procedure to run the queries as required and scheduling a job (at 2:00pm each day) to run the stored procedure ?
Steve
 
Thanks a lot for this answer.

P.S:If you have a time ,i want to write me a simple for this stored procedure .
This stored procedure should be contains a 25 querie
(like select * from table).
Thanks again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top