Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dtrivedi
Posting Yak Master
153 Posts |
 Posted - 2010-10-26 : 14:39:35
|
| Is it possible to scedueal a procedure to run automatically? how would I do that? I have the store procedure created already. this is the execution statement. USE [CACTUSDB]GODECLARE @return_value intEXEC @return_value = [dbo].[Auto_Finalize_Prev_Days]SELECT 'Return Value' = @return_valueGO |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-10-26 : 15:24:03
|
| okay where can i go for more information on how to scheduel it? |
 |
|
|
psychotic_savage
Starting Member
25 Posts |
Posted - 2010-10-27 : 04:39:26
|
| http://msdn.microsoft.com/en-us/library/ms191439.aspxGoogle is your friend :) |
|
|
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2010-10-27 : 10:02:03
|
| thanks alot. But the issue is the database is not on the SQL Server it's on SQL Express which doesn't have sql server agent. what can be my other options? Can I link the job thru another database which is on the sql server and remotely do it? If so how? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Schedueling a Job to run automatically