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.
| Author |
Topic |
|
youngster
Starting Member
10 Posts |
 Posted - 2007-11-29 : 09:33:22
|
| EXEC msdb.dbo.sp_start_job @job_name = 'the_job'yet I can not find 'the_job' under Management -> SQL Server Agent -> JobsWhy is this so? Where could the job be? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-29 : 09:40:40
|
| have a look in sysjobs in the msdb. |
 |
|
|
RicoLX
Starting Member
3 Posts |
Posted - 2007-11-30 : 11:50:34
|
| I may be way off on this but i first created a DTS package and scheduling it to run once, then I would see the Job in the management folder where can be called to execute from codeRicoLX |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:23:25
|
| If you are not sysadmin and don't have proper permission in msdb, you'll not see jobs owned by other sql logins. |
|
|
|
|
|
|
Can not find job