用sql语句创建sql job的模板
来源:互联网 发布:淘宝cpu鞋旗舰店真假 编辑:程序博客网 时间:2024/06/06 09:26
注:用 YOUR_SQL_JOB_NAME 替换成真实的 sql job name
运行环境:sql server 2005, 2008, 2008 R2, 2010, 2012
USE [msdb]GO/****** Object: Job [YOUR_SQL_JOB_NAME] Script Date: 2/20/2014 4:39:52 AM ******/IF EXISTS (SELECT job_id FROM msdb.dbo.sysjobs_view WHERE name = N'YOUR_SQL_JOB_NAME')EXEC msdb.dbo.sp_delete_job @job_name=N'YOUR_SQL_JOB_NAME', @delete_unused_schedule=1GO/****** Object: Job [YOUR_SQL_JOB_NAME] Script Date: 2/20/2014 4:39:52 AM ******/BEGIN TRANSACTIONDECLARE @ReturnCode INTSELECT @ReturnCode = 0/****** Object: JobCategory [[Uncategorized (Local)]]] Script Date: 2/20/2014 4:39:52 AM ******/IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)BEGINEXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackENDDECLARE @jobId BINARY(16)EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'YOUR_SQL_JOB_NAME', @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'[Uncategorized (Local)]', --@owner_login_name=N'JobCreator', @owner_login_name=N'sa', @job_id = @jobId OUTPUTIF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback/****** Object: Step [1] Script Date: 2/20/2014 4:39:53 AM ******/EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'1', @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'SSIS', @command=N'/FILE "E:\SSIS\YOUR_SQL_JOB_NAME\YOUR_SQL_JOB_NAME.dtsx" /CHECKPOINTING OFF /SET "\Package.Variables[User::ParentName].Properties[Value]";YOUR_SQL_JOB_NAME /REPORTING E', @database_name=N'master', @flags=0 --,@proxy_name=N'Proxy'IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackEXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackEXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollbackCOMMIT TRANSACTIONGOTO EndSaveQuitWithRollback: IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTIONEndSave:GO
0 0
- 用sql语句创建sql job的模板
- 利用sql语句创建job
- oracle Sql 语句创建JOB
- PL/SQL导出JOB创建语句
- 清点数据库Job情况的SQL语句
- SQL语句的创建
- sql server 创建job
- sql server 创建job的存储过程
- PL/SQL Developer创建Job的步骤
- PL/SQL Developer创建Job的步骤
- PL/SQL Developer创建Job的步骤
- PL/SQL Developer创建Job的步骤
- PL/SQL Developer创建Job的步骤
- PL/SQL Developer创建Job的步骤
- 创建优化的SQL语句
- sql语句脚本的创建
- 创建squece的sql语句
- SQL数据库的创建语句
- 然而世上有太多事与愿违。。
- EM故障,重新创建em
- camera flicker--- what why and how
- UML类图几种关系的总结
- php gd库
- 用sql语句创建sql job的模板
- Android上面做Flash播放器
- 如何进入虚拟机WMWare的BIOS设置界面
- robot framework + selenium2library安装步骤
- ListView 实现点击侧边A-Z快速查找[中英文排序混排]
- Linux下定时执行脚本
- 遵守csdn博客规则,写出最原创的文章
- Spring 开发
- 传苹果或推出安卓版iTunes音乐商店