I can execute the following file to create jobs/ job
 steps/ and related job schedules in SQL Analyzer ...
 however the job is never scheduled. I can not identify
 anything that is incorrect.
 The commands process properly... and I can browse the
 resulting msdb table entries in sys_jobs, sys_jobsteps,
 and sys_jobschedules... however nothing ever gets
 scheduled.
 Please provide assistance where appropriate.
 USE MSDB
 EXEC sp_add_job
 @.job_name='MailPointDBEmailFTCTPopulation',
 @.enabled=1,
 @.notify_level_eventlog=3
 EXEC sp_add_jobstep
 @.job_name='MailPointDBEmailFTCTPopulation',
 @.step_name='EmailFTCTPopulation',
 @.subsystem='TSQL',
 @.command='EXEC sp_fulltext_table Email, ''update_index'''
 EXEC sp_add_jobschedule
 @.job_name='MailPointDBEmailFTCTPopulation',
 @.name='MailPointDBEmailFTCTPopulation',
 @.enabled=1,
 @.freq_type=4,
 @.freq_interval=1,
 @.active_start_time=183000
 EXEC sp_add_job
 @.job_name='MailPointDBDocumentFTCTPopulation',
 @.enabled=1,
 @.notify_level_eventlog=3
 EXEC sp_add_jobstep
 @.job_name='MailPointDBDocumentFTCTPopulation',
 @.step_name='DocumentFTCTPopulation',
 @.subsystem='TSQL',
 @.command='EXEC sp_fulltext_table
 Document, ''update_index'''
 EXEC sp_add_jobschedule
 @.job_name='MailPointDBDocumentFTCTPopulation',
 @.name='MailPointDBDocumentFTCTPopulation',
 @.enabled=1,
 @.freq_type=4,
 @.freq_interval=1,
 @.active_start_time=183000
 GOis agent running on your server ?
jobi
"Philip" <plippard@.nc.rr.com> wrote in message
news:154f01c35247$39bb07a0$a001280a@.phx.gbl...
> I can execute the following file to create jobs/ job
> steps/ and related job schedules in SQL Analyzer ...
> however the job is never scheduled. I can not identify
> anything that is incorrect.
> The commands process properly... and I can browse the
> resulting msdb table entries in sys_jobs, sys_jobsteps,
> and sys_jobschedules... however nothing ever gets
> scheduled.
> Please provide assistance where appropriate.
> USE MSDB
> EXEC sp_add_job
> @.job_name='MailPointDBEmailFTCTPopulation',
> @.enabled=1,
> @.notify_level_eventlog=3
> EXEC sp_add_jobstep
> @.job_name='MailPointDBEmailFTCTPopulation',
> @.step_name='EmailFTCTPopulation',
> @.subsystem='TSQL',
> @.command='EXEC sp_fulltext_table Email, ''update_index'''
> EXEC sp_add_jobschedule
> @.job_name='MailPointDBEmailFTCTPopulation',
> @.name='MailPointDBEmailFTCTPopulation',
> @.enabled=1,
> @.freq_type=4,
> @.freq_interval=1,
> @.active_start_time=183000
> EXEC sp_add_job
> @.job_name='MailPointDBDocumentFTCTPopulation',
> @.enabled=1,
> @.notify_level_eventlog=3
> EXEC sp_add_jobstep
> @.job_name='MailPointDBDocumentFTCTPopulation',
> @.step_name='DocumentFTCTPopulation',
> @.subsystem='TSQL',
> @.command='EXEC sp_fulltext_table
> Document, ''update_index'''
> EXEC sp_add_jobschedule
> @.job_name='MailPointDBDocumentFTCTPopulation',
> @.name='MailPointDBDocumentFTCTPopulation',
> @.enabled=1,
> @.freq_type=4,
> @.freq_interval=1,
> @.active_start_time=183000
> GO
>
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment