I was wondering if anyone knew how to create a job that will run the first 4 days of the month in SQL Server 2000? I found how to run a job once on the first or second day, but the only way I figured I could run each of the four days would be to create a job for each day meaning I would have 4 jobs created. I was hoping for a better way.
我想知道是否有人知道如何在SQL Server 2000中创建一个将在该月的前4天运行的作业?我发现如何在第一天或第二天开始工作一次,但我认为我可以在四天中每一天运行的唯一方法就是每天创造一份工作,这意味着我将创造4个工作岗位。我希望有更好的方法。
2 个解决方案
#1
Instead of creating 4 jobs, you can create one job with 4 schedules.
您可以使用4个计划创建一个作业,而不是创建4个作业。
Fire up enterprise manager, create your job as you normally would and on the schedules tab of the Job properties add 4 schedules, one for each day of the month you'd like the job to run.
启动企业管理器,像往常一样创建工作,并在“作业”属性的“日程表”选项卡上添加4个计划,每个日期对应于您希望运行作业的每个月。
#2
Sorry I don;t have SQL 2000 to hand but can you not once the job is created add 4x schedules to the job (Edit Job > New Schedule or similar)
抱歉,我没有提供SQL 2000,但是一旦创建了作业,你就不能为作业添加4x计划(编辑作业>新计划或类似计划)
Sorry if this isn't available, you can use this method in 2008
很抱歉,如果没有,您可以在2008年使用此方法
he he, As Jason says
他,正如杰森所说
#1
Instead of creating 4 jobs, you can create one job with 4 schedules.
您可以使用4个计划创建一个作业,而不是创建4个作业。
Fire up enterprise manager, create your job as you normally would and on the schedules tab of the Job properties add 4 schedules, one for each day of the month you'd like the job to run.
启动企业管理器,像往常一样创建工作,并在“作业”属性的“日程表”选项卡上添加4个计划,每个日期对应于您希望运行作业的每个月。
#2
Sorry I don;t have SQL 2000 to hand but can you not once the job is created add 4x schedules to the job (Edit Job > New Schedule or similar)
抱歉,我没有提供SQL 2000,但是一旦创建了作业,你就不能为作业添加4x计划(编辑作业>新计划或类似计划)
Sorry if this isn't available, you can use this method in 2008
很抱歉,如果没有,您可以在2008年使用此方法
he he, As Jason says
他,正如杰森所说