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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Schedueling a Job to run automatically

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]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[Auto_Finalize_Prev_Days]

SELECT 'Return Value' = @return_value

GO

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-26 : 15:07:47
Yes, add a job via the SQL Server Agent.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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?
Go to Top of Page

psychotic_savage
Starting Member

25 Posts

Posted - 2010-10-27 : 04:39:26
http://msdn.microsoft.com/en-us/library/ms191439.aspx
Google is your friend :)

Go to Top of Page

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?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-27 : 11:59:34
Here you go: http://weblogs.sqlteam.com/mladenp/archive/2008/08/28/SQL-Server-2005-Express-Job-Scheduling---Part-1.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -