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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-09 : 08:26:03
|
Christianne writes "Hi
How I know (in transact - sql) all jobs and it schedulles and what database has this jobs (time - hour- week ) exist in my server?
i try this :
select e.name , d.name
from sysjobs e join sysjobschedules d on e.id_job = d.id_job
However , then result show only name of schedulle not show time/date ( when this job must be executed) ...
Do you help me?" |
|
|
|
|
|
Job Schedulle