Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Schedule a job in sql server agent Expand / Collapse
Author
Message
Posted Wednesday, January 27, 2010 6:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, June 6, 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
Posted Wednesday, January 27, 2010 9:06 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 4,065, Visits: 5,298
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
Posted Saturday, January 30, 2010 5:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 27, 2014 8:38 AM
Points: 80, Visits: 48
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
Posted Wednesday, February 3, 2010 10:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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 »

Add to briefcase

Permissions Expand / Collapse