May 19, 2014 at 11:41 am
We have a job schedule (Nightly 12:30 a.m.) which uses a 'Daily' schedule that is associated with multiple jobs. We have found some of those jobs using this schedule we want to move to a weekly job that fires Mon through Saturday at 12:30 and then a separate weekly job to run on Sunday at 5:30 a.m.
Example
Job A performs task ABC using job schedule Nightly 12:30 a.m. (we want to change this one to Mon-Saturday at 12:30 and Sunday at 5:30)
Job B performs task XYZ using job schedule Nightly 12:30 a.m. (we want this to remain with same schedule)
We have determined that Job A should no longer fire on Sunday at 12:30 am but instead at 5:30 a.m.
Our thought is that we create a Weekly 12:30 a.m. that will fire on Monday through Saturday
and another schedule Weekly 5:30 a.m. that will fire on Sunday and associate both the schedules to Job A
Job B we don't want to change the schedule.
Can anyone tell me if we 'Disable' the schedule called Nightly 12:30 a.m. from Job A and then associate the Weekly Mon-Saturday and Weekly Sunday to this job, will Job B still be able to use the schedule called Nightly 12:30 a.m.?
From my research, if I 'Disable' the Nightly 12:30 a.m. job schedule from Job A I see that the schedule as a whole is Disabled from the dbo.sysSchedules table. My concern is that Job B will NOT continue to fire Nightly at 12:30.
Is there another recommendation with how to accomplish this? Should I 'Remove' the Nightly 12:30 fires daily from Job A after I add the 2 Weekly schedules? Would this ensure that Job B will still utilze Nightly at 12:30 since it is still associated with Job B and hasn't been removed from Job B and is still officially 'enabled' in dbo.SysSchedules
May 20, 2014 at 5:37 am
Hi,
You can goto the job properties and then remove the shared schedule showing under the Schedule tab.
Once the shared schedule is removed you can then create new one as per your requirement.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply