Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vengateshs
Starting Member
3 Posts |
 Posted - 2009-12-16 : 14:04:19
|
| Hi,I have created a Job and a schedule. Then, I tried to attach the job with schedule by executing the following stored procedureEXEC sp_attach_schedule @job_name='Job1', @schedule_name='Schedule1';But the execution of this SP resulted with the following error:Msg 14371, Level 16, State 1, Procedure sp_verify_schedule_identifiers, Line 113There are two or more schedules named "Schedule1". Specify @schedule_id instead of @schedule_name to uniquely identify the schedule.At this point of time, I do not know the schedule_id and I want to attach the schedule by specifying the schedule_name. Please help...-Vengatesh |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-16 : 16:27:05
|
| [code]use msdb;goselect *from sysscheduleswhere name = 'Schedule1'and date_created > '20091212'[/code] |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-16 : 16:28:18
|
by the way, scheduling jobs is one of the very few things i use the gui for.  |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2009-12-16 : 21:09:15
|
| Yes, use the gui, why make it difficult for yourself ? Most things done through the gui can also be made into a script to see how it's done. |
|
|
|
vengateshs
Starting Member
3 Posts |
Posted - 2009-12-16 : 23:02:22
|
| Thanks guys!I looked at the list of schedules present in the table 'sysschedules' and found there were too many occurences with the same schedule name (of course, they were created by me while practising ;-))-Vengatesh |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
sp_attach_schedule