Mutiple scheduling of a job sql 2000

Last Post 24 Mar 2009 03:17 PM by Huifong. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Huifong
New Member
New Member

--
23 Mar 2009 08:51 PM
I have a job runs once weekly and also once at the end of each month. Becuase they are the same job, I just added two schedulings within the job. However when I forced to run the jobs to test ( by changing the date/time via the 'Control Panel'), it seems that the second schedule didn't get run, as it doesn't apprea in either the job history, in the 'Last Run Status(Start Date)', nor the 'Next Run Date'.

I know that I can simply add another job and schedule it once of a month. But I thought that defining them in one job is easy to manage as they are the same job.

Any advice?

Thanks!
Huifong
New Member
New Member

--
24 Mar 2009 03:17 PM
I can see the job's results now, which I didn't check it at the beginning. I only looked at the Job's console.

So it's better to check related tables for a job's result, rather than merely look at the job's console for the last run and next run dates..... which might not be apparent some times.

Thank you rm. I know that you are always very helpful !


Acceptable Use Policy
---