July 8, 2002 at 12:57 pm
Does any one know how to find the schedule that ran the job while the job is running?
I would like to make a decision in the stored procedure that will do something only on the night schedule but I do not want to create another job with a whole new schedule.
July 8, 2002 at 2:16 pm
look in msdb.dbo.sysjobschedules. You can query from here.
Preferred: sp_help_job
Steve Jones
July 8, 2002 at 3:09 pm
Thanks for the response Steve, however I don't know if you got my drift. Let me elborate.
The job has two schedules and one step
While the job is running I would like the step to know which schedule is running it.
Is this possible?
July 8, 2002 at 5:12 pm
You would have to correlate the current time with the job schedules to determine which is running.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply