Scheduled Jobs

#1

I have created several scheduled jobs a few update some tables while the rest
are the Backups, made with the DB Maint. Plan Wizard. The ones that updated
the tables will not work while I am sitting at my computer but they will if I
am working on the server. I am using remote desktop when working at my
computer, when the jobs do not work. That started about a week ago. Now the
maint. plan schedules will not work at either place. I am new to SQL Server
and could use some help. I have not done much with this part of SQL Server.

Thanks
-Adam-

#2

You created these jobs with the Maintenance plan wizards?

The tasks that you describe would be possible to do in the wizard using SQL
Server 2005 but not 2000.

Are you using DTS at all?

"A.B." <AB (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have created several scheduled jobs a few update some tables while the
rest
are the Backups, made with the DB Maint. Plan Wizard. The ones that
updated
the tables will not work while I am sitting at my computer but they will
if I
am working on the server. I am using remote desktop when working at my
computer, when the jobs do not work. That started about a week ago. Now
the
maint. plan schedules will not work at either place. I am new to SQL
Server
and could use some help. I have not done much with this part of SQL
Server.

Thanks
-Adam-

#3

The updates where done witht the DTS import wizard. Actually though they
started working again. I changed nothing and now they all work.

"Allan Mitchell" wrote:

Quote:

You created these jobs with the Maintenance plan wizards?

The tasks that you describe would be possible to do in the wizard using SQL
Server 2005 but not 2000.

Are you using DTS at all?

"A.B." <AB (AT) discussions (DOT) microsoft.com> wrote in message
news:7BFCDE34-0776-4557-B10F-48A7588E2622 (AT) microsoft (DOT) com...
I have created several scheduled jobs a few update some tables while the
rest
are the Backups, made with the DB Maint. Plan Wizard. The ones that
updated
the tables will not work while I am sitting at my computer but they will
if I
am working on the server. I am using remote desktop when working at my
computer, when the jobs do not work. That started about a week ago. Now
the
maint. plan schedules will not work at either place. I am new to SQL
Server
and could use some help. I have not done much with this part of SQL
Server.

Thanks
-Adam-

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Scheduled Jobs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Scheduled Jobs - 08-26-2005 , 08:01 AM

Re: Scheduled Jobs - 08-27-2005 , 02:48 AM

Re: Scheduled Jobs - 08-29-2005 , 09:15 AM