Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Job Scheduler.

Status
Not open for further replies.
riya

riya

Programmer
Mar 1, 2001
12
0
0
IN
Hi all,
How to use a sp_add_job and sp_add_jobschedule?
I have a sp which i have to run daily at particular time.How am I supposed to associate the sp with the job?

Thanx in advance
 
Sort by date Sort by votes
You might wanna use the Job Scheduling wizard from Enterprose Manager. It might be somthing you want to look at
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
46
pjw001
pjw001
BTrees
  • Locked
  • Question
How Check status of Agent Job from other server
Replies
0
Views
46
BTrees
BTrees
codrutza
  • Locked
  • Question
Select Result One Record Per Job 2
2
Replies
20
Views
89
SkipVought
S
Cpreston
  • Locked
  • Question
Job not running 1
Replies
5
Views
51
SQLBill
SQLBill
junkmail
  • Locked
  • Question
schedule job aborts
Replies
4
Views
32
junkmail
junkmail

Part and Inventory Search

Sponsor

Back
Top