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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Job

Status
Not open for further replies.
sardinka2

sardinka2

Programmer
May 6, 2004
38
US
it is some how I can find out programatically job name,schedule time, sucess/fail?
 
Sort by date Sort by votes
probably the easiest way to do this is to create your own sp which returns just the fields you need based on sp_help_job. There also are quite a few other sp_help_job* sp's which give specific information in msdb
 
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
280
pjw001
pjw001
BTrees
  • Locked
  • Question
How Check status of Agent Job from other server
Replies
0
Views
167
BTrees
BTrees
codrutza
  • Locked
  • Question
Select Result One Record Per Job 2
2
Replies
20
Views
609
SkipVought
S
Cpreston
  • Locked
  • Question
Job not running 1
Replies
5
Views
225
SQLBill
SQLBill
junkmail
  • Locked
  • Question
schedule job aborts
Replies
4
Views
182
junkmail
junkmail

Part and Inventory Search

Sponsor

Back
Top