|
saati gelince raporu html dosyasi olarak üretiyor sonra mail atmasi gerek ancak data base mail loglarina bakiyorum servis durmus gözüküyor. database mail den test mail gönderirken sikinti yok ancak bu tip joblardan göndermesi gereken maillerde servis duruyor USE [msdb]
GO
/****** Object: Job [stok_bakiye20] Script Date: 12/13/2012 14:06:47 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object: JobCategory [Database Maintenance] Script Date: 12/13/2012 14:06:47 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'Database Maintenance' AND category_class=1)
BEGIN
EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'Database Maintenance'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
END
DECLARE @jobId BINARY(16)
EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'stok_bakiye20',
@enabled =1,
@notify_level_eventlog =0,
@notify_level_email =0,
@notify_level_netsend =0,
@notify_level_page =0,
@delete_level =0,
@description =N'No description available.',
@category_name =N'Database Maintenance',
@owner_login_name =N'sa', @job_id = @jobId OUTPUT
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
/****** Object: Step [adim1] Script Date: 12/13/2012 14:06:47 ******/
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'adim1',
@step_id =1,
@cmdexec_success_code =0,
@on_success_action =1,
@on_success_step_id =0,
@on_fail_action =2,
@on_fail_step_id =0,
@retry_attempts =0,
@retry_interval =0,
@os_run_priority =0, @subsystem=N'TSQL',
@command =N'exec sp_makewebtask ''c:\otorapor\STOK_BAKIYESI.html'',
@QUERY=''SELECT * from GUNLUK_20_DEPOBAKIYESI where [STOK MIKTARI]>-1 '',
@resultstitle=''GNLK STOK BAKIYE RAPORU'',
@colheaders =1,
@FixedFont=0,
@lastupdated=0
exec msdb..sp_send_dbmail
@profile_name=''YEDEKLEME'',
@subject =''Gnlk Stok Raporu '',
@body =''MERHABALAR GNLK STOK RAPORU AN iTiBARiYLE OTOMATK OLARAK OLUTURULARAK EKTE SUNULMUTUR. Y ALIMALAR. zka Lastik A.. Bilgi lem...'',
@recipients=''deneme@deneme.com;deneme1@deneme.com'',
@copy_recipients=''mudur@deneme.com'',
@file_attachments =''c:\otorapor\STOK_BAKIYESI.html'';
' ,
@database_name =N'DENEME2012',
@flags =0
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'1',
@enabled =1,
@freq_type =8,
@freq_interval =127,
@freq_subday_type =1,
@freq_subday_interval =0,
@freq_relative_interval =0,
@freq_recurrence_factor =1,
@active_start_date =20121212,
@active_end_date =99991231,
@active_start_time =103000,
@active_end_time =235959
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback :
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave :
|