Steps to schedule a SP - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Steps to schedule a SP

Author

Topic

satya068
Posting Yak Master

233 Posts

Posted - 2010-04-07 : 09:16:04

Hi

i am trying to schedule my SP inthe PAS_RDB database to run every day morning at 8:30am

can any tell me the steps to follow in sql server agent pls.

thanx

Satya

whitmoj
Yak Posting Veteran

68 Posts

Posted - 2010-04-07 : 09:17:21

You will need to create a Job for this to happen.

Whitmoj
If I have inspired one person today then my job is done.

satya068
Posting Yak Master

233 Posts

Posted - 2010-04-07 : 09:21:51

Hi..
I
already created a SP_FULL_PAS_DAILY_RECORD_COUNT inthe database i use to run this manually but i want this to schedule.

Satya

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-04-07 : 09:23:03

Goto Schedules and set the time there

Madhivanan

Failing to plan is Planning to fail

satya068
Posting Yak Master

233 Posts

Posted - 2010-04-07 : 09:36:58

i was wondering

under sql server agent
in the steps which i above schedule
opposite to command i given exec SP_FULL_PAS_DAILY_RECORD_COUNT

and click OK

next i am going to schedules and i am scheduling the job, is this correct way of scheduling

Satya

satya068
Posting Yak Master

233 Posts

Posted - 2010-04-07 : 09:49:54

hi..guys,

thanx for ur help,i managed to schedule my SP.

Satya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources