I'm doing some database maintenance by erasing DTSs and jobs that are needed
anymore.

I've noticed that there are jobs that don't have a corresponding DTS.

Four jobs called TSQL_JOB_4 - TSQL_JOB_7 do not have corresponding DTS. This
is the detail of these jobs:
[Last Run Status] = "Unknown"
[Enabled] = 'No'
[Runnable] = 'Yes'
Two of them have [Scheduled] = 'No' and the other two have [Scheduled] =
'Yes'. [Status]="Not Running"

There's another job called "Make History" that's [Enabled]='Yes',
[Runnable]='Yes', [Scheduled]='Yes', [Last Run Status]='Succeeded
(8/5/2008)', [Next Run Date]='9/5/2008'. But I don't have a DTS called "Make
History".
All these jobs have the blue icon.

Then I have some with the red 'X' icon next to them, and they're also jobs
with no corresponding DTS. I have a job called "FullDB_Backup" that's
[Enabled]='Yes', [Runnable]='Yes', [Scheduled]='Yes', [Status]="Not Running",
[Last Run Status]='Failed (8/24/2008)', [Next Run Date]='8/25/2008'.
There are a few more like this.

What should I do with them? Can I create a job that's unrelated to a DTS?

Any help is appreciated.

I have SQL Server 2000.
Thanks.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.

On Aug 25, 4:20*pm, VMI <V... (AT) discussions (DOT) microsoft.com> wrote:
Hi,
DTS and jobs are two different objects, sometimes related because you
can schedule a DTS in a job, but this doesn't mean that for each job
there must be an underlying DTS. In fact you can create jobs that
perform tasks other thatn DTS (execute activeX script, perform some
simple maintenace tasks, execute tsql statements or, for DTS,
executing commands). Open your job and go to the step tab. Open a
single step and check the step type. For DTS this should be CmdExec.
Then check the command: if there's DTSRun /N"YourDTSname" and the DTS
isn't stored... well i believe the job will fail.

HTH,
M.