Schedule a job in sql server agent

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » Schedule a job in sql server agent

Schedule a job in sql server agent

Rate Topic

Display Mode

Topic Options

Author

Message

KpSQL123

Posted Wednesday, January 27, 2010 6:35 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, June 06, 2012 2:50 AM
Points: 19, Visits: 47

Hi,

Can some one please tell me how to schedule a job in SQl server agent.

Actually i have one stored procedue which contains the update statement. I need to schedule this stored procedure to execute on daily basis.

any help would be helpful.

Post #854329

Greg Charles

Posted Wednesday, January 27, 2010 9:06 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:45 AM
Points: 4,007, Visits: 4,851

This is explained thoroughly in BookOnLine. Also in this thread posted this morning: http://www.sqlservercentral.com/Forums/Topic853971-145-1.aspx.

Greg

Post #854472

ganaparthi.jagadeesh

Posted Saturday, January 30, 2010 5:17 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 4:04 AM
Points: 76, Visits: 36

Hi,

Create a job.....under that you will steps add yout sp statement in that click ok..below that step one more thing is with schedule under that you can schedule ..for how many you want to run that job bla bla......

Post #856633

cafc

Posted Wednesday, February 03, 2010 10:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, August 13, 2010 11:53 AM
Points: 31, Visits: 113

Hi,
Can anyone explain how I can set a job to process my Cube (SSAS) on sql server 2008?
Thanks in advance.
Cafc

Post #858839

« Prev Topic | Next Topic »

Permissions