As Allan mentioned, if you are right clicking on the package and saying
"Schedule" then thiswill create another SQL Server Agent job not alter the
one you did previously.
To actually change the schedule of the job previously created, you would go
to Management | SQL Server Agent | Jobs in Enterprise Manager, locate the
job, open its Properties dialog, change the schedule on the Schedules tab.
When you right-click and schedule the package, you would see a "Job name"
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft Support Engineer
| Content-Class: urn:content-classes:message
| Subject: Re: Unable to reschedule package
| Date: Tue, 1 Apr 2003 09:39:59 -0800
| Lines: 41
| MIME-Version: 1.0
| Content-Type: text/plain;
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcL4dbfKc0tIrPXaSJ2BHjYlp+Lr/Q==
| Newsgroups: microsoft.public.sqlserver.dts
| Path: cpmsftngxa08.phx.gbl
| Xref: cpmsftngxa08.phx.gbl microsoft.public.sqlserver.dts:31137
| NNTP-Posting-Host: TK2MSFTNGXA04 10.40.1.52
| X-Tomcat-NG: microsoft.public.sqlserver.dts
| Yes, that is what I am doing. So, what is the navigation
| to actually bring up an existing package and change the
| scheduling on it?
| Dean Slindee
Quote:| >-----Original Message-----
| >Hello, Dean!
| >How are you scheduling the Package ?
| >If you are right clicking on the package and
| saying "Schedule" then this
| >will create another SQL Server Agent job not alter the
| one you did
| >Allan Mitchell (Microsoft SQL Server MVP)
| >I support PASS - the definitive, global community
| >for SQL Server professionals - http://www.sqlpass.org
| >: I had a package scheduled to run daily at midnight. I
| changed the
| >: checkboxes to reschedule it to run weekly, and then
| saved the changes.
| >: However, upon redisplaying the same package again, it
| still is scheduled
| >: daily execution. Why are the changes not being saved?
| >: Thanks,
| >: Dean S
| > --- Microsoft Outlook Express 6.00.3663.0