Job Scheduling For Packages In SQL Server 2005

Aug 31, 2006

----------------------
MS Win XP Pro 2002 SP2
MS SQL Server 2005
MS Visual Studio 2005
----------------------

Can anyone help me (even by pointing me to a documentation) in order to schedule Packages (from file system source) in SQL Server 2005.

I've configured providers logging, but still the error file doesn't give me any explanation why the error happens:
"#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,PC1234,NT AUTHORITYSYSTEM,D_AGR,{8A4FA774-F5F0-40DE-AB16-A93F27950E09},{8A918844-8E43-403D-A606-C8CB4B7D8238},31/08/2006 16:42:55,31/08/2006 16:42:55,0,0x,(null)"

I've also done the same on the Step properties under 'Logging'

In Management Studio I've added my login name and I'm the only user using the machine and I manage both Visual Studio and Management Studio

The error coming up on the job history is as follow: "Executed as user: PC1234SYSTEM. The package execution failed. The step failed." "The job failed. The Job was invoked by User UK1USER123. The last step to run was step 1 (step1)."

By the way the package (.dtsx) runs fine in BI Visual Studio)

Thank you very much.

View 16 Replies

Scheduling The Legacy DTS 2000 Packages In Sql Server 2005?

Sep 12, 2007

Hi Experts

I am trying to schedule a legacy DTS 2000 package in 64 bit Sql Server 2005.

I cannot use the DTSRun tool on the Command prompt of the Sql 2005. What about dtexec ?Can i run Sql Server 2000 DTS packages from the Command Prompt.

Is DTS 2000 the only way to do that?

Any Advise is greatly appreciated

Vic.

View 5 Replies View Related

Scheduling SQL 2005 SSIS Packages

May 9, 2007

I have created and run SSIS packages from my workstation that are successful. When I Build and then Deploy the same package to the server and schedule it, it fails. I am using SQL authentication connecting from a SQL 2000 database to a SQL 2005 database via OLE DB connections.

The following is the exported result of the package...

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted

05/09/2007 15:46:05,AMS_EnterpriseWarehouse,Error,0,AMSBINT1,AMS_EnterpriseWarehouse,(Job outcome),,The job failed. The Job was invoked by User JDEREP. The last step to run was step 1 (step1).,00:00:01,0,0,,,,0

05/09/2007 15:46:05,AMS_EnterpriseWarehouse,Error,1,AMSBINT1,AMS_EnterpriseWarehouse,step1,,Executed as user: AMSOILvector. Error: 2007-05-09 15:46:06.38 Code: 0xC0047017 Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: component "F0005" (1) failed validation and returned error code 0xC020801C. End Error Error: 2007-05-09 15:46:06.38 Code: 0xC004700C Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-05-09 15:46:06.38 Code: 0xC0024107 Source: JDE Production to AMS BI 7332 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:46:05 PM Finished: 3:46:06 PM Elapsed: 0.75 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0
05/09/2007 15:30:00,AMS_EnterpriseWarehouse,Error,0,AMSBINT1,AMS_EnterpriseWarehouse,(Job outcome),,The job failed. The Job was invoked by Schedule 29 (AMS_EnterpriseWarehouse). The last step to run was step 1 (step1).,00:00:01,0,0,,,,0
05/09/2007 15:30:00,AMS_EnterpriseWarehouse,Error,1,AMSBINT1,AMS_EnterpriseWarehouse,step1,,Executed as user: AMSOILvector. Error: 2007-05-09 15:30:01.15 Code: 0xC0047017 Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: component "F0005" (1) failed validation and returned error code 0xC020801C. End Error Error: 2007-05-09 15:30:01.15 Code: 0xC004700C Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-05-09 15:30:01.15 Code: 0xC0024107 Source: JDE Production to AMS BI 7332 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:30:00 PM Finished: 3:30:01 PM Elapsed: 0.734 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0
05/09/2007 15:20:00,AMS_EnterpriseWarehouse,Error,0,AMSBINT1,AMS_EnterpriseWarehouse,(Job outcome),,The job failed. The Job was invoked by Schedule 29 (AMS_EnterpriseWarehouse). The last step to run was step 1 (step1).,00:00:01,0,0,,,,0
05/09/2007 15:20:00,AMS_EnterpriseWarehouse,Error,1,AMSBINT1,AMS_EnterpriseWarehouse,step1,,Executed as user: AMSOILvector. Error: 2007-05-09 15:20:01.55 Code: 0xC0047017 Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: component "F0005" (1) failed validation and returned error code 0xC020801C. End Error Error: 2007-05-09 15:20:01.55 Code: 0xC004700C Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-05-09 15:20:01.55 Code: 0xC0024107 Source: JDE Production to AMS BI 7332 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:20:00 PM Finished: 3:20:01 PM Elapsed: 0.703 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0
05/09/2007 15:18:00,AMS_EnterpriseWarehouse,Error,0,AMSBINT1,AMS_EnterpriseWarehouse,(Job outcome),,The job failed. The Job was invoked by Schedule 29 (AMS_EnterpriseWarehouse). The last step to run was step 1 (step1).,00:00:01,0,0,,,,0
05/09/2007 15:18:00,AMS_EnterpriseWarehouse,Error,1,AMSBINT1,AMS_EnterpriseWarehouse,step1,,Executed as user: AMSOILvector. Error: 2007-05-09 15:18:01.53 Code: 0xC0047017 Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: component "F0005" (1) failed validation and returned error code 0xC020801C. End Error Error: 2007-05-09 15:18:01.53 Code: 0xC004700C Source: JDE Production to AMS BI 7332 DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-05-09 15:18:01.53 Code: 0xC0024107 Source: JDE Production to AMS BI 7332 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 3:18:00 PM Finished: 3:18:01 PM Elapsed: 0.766 seconds. The package execution failed. The step failed.,00:00:01,0,0,,,,0

Any help would be greatly appreciated...

Jim

Additionally, when I run this from the command line, I get the following

DTSER_FAILURE (1)

Jim

View 7 Replies View Related

Scheduling DTS Packages

Oct 9, 2000

I have seen lots of messages on scheduling DTS packages, but none have solved my specific problem.
I could manually run my local DTS package, but it wouldn't run when I scheduled it. The problem was with connecting using OLE DB provider. I checked everything: my NT account had all relevant permissions, as did the SQL Server agent account. I tried playing around with the job owner.

In the end, the only thing that worked was if I physically created the local DTS package on the Server rather than sitting at my workstation (still under my NT account though - I even logged on to the server with my NT account). The job then ran fine.

I think it is something to do with NT authentication (as I never got the problem before using NT auth). Can anyone shed any light on it? Is it something to do with the fact that with NT authentication the workstation ID is an advanced property of the OLE DB connection?

View 2 Replies View Related

Scheduling The Packages To Run.

Jul 1, 2007

Hi,
I have two packages in my SSIS Packages Folder. What I need is to schedule this Packages to run. ( as Package 1 then Package 2 ).

Please do heal me in doing the needful.

View 3 Replies View Related

Scheduling Multiple DTS Packages

Jan 2, 2002

I have several independant DTS packages that I would like to schedule and run as 1 job stream. (sql2000) I can schedule them individually, but I would prefer to have each one be a step of 1 big scheduled job.

Any ideas ?

View 2 Replies View Related

Help! Scheduling SSIS Packages

Oct 10, 2007

Hi all!
I just started a new job, and im a junior programmer, so have no idea about anything yet...
My boss asked me to run a SSIS package weekly. I found out that I can do it throught the SQLServer Agent job task. Am I right? As i'm not sure about it.

Well I configure it, first as a Transact-Sql with the cmdShell, and it gave me an error like I have to start the messenger Service, I cannot do it as i'm not as administrator. Any way to sort this problem out?

Another thing I could do, I guess is configure the job as a SQL Server Integration package, but it doesn't find my package. Should I save it in a special path??

Any help would be great! As I'm really lost in it, and I've been 3 days trying to sort it out, with no luck. My boss is expecting me to do it by tomorrow...

Oh... finally, I guess I should add a Execute sql job task in the SSIS package? I've already done it, but it may be wrong.

View 6 Replies View Related

Scheduling SSIS Packages In SS2005

Feb 21, 2008

I'm trying to create a SQL Agent job and schedule that executes an SSIS Package, but when I try to run the job I get the following error:

Executed as user: adApp1. The package could not be loaded.

The App1 user is the Identity used in the Credential for the Proxy which has the SSIS Packages Subsystem.
The package encryption is set EncryptAllWithPassword and that password is included in the Command line with the /DECRYPT option.
The package is stored on the server in the SSIS Package Store and was placed there via the Import package option. Does the method matter?

One thing that I haven't been able to track down is exactly what permissions the domain account adApp1 needs on the server or in SQL Server, if any, in order to run the package. Not sure if that has any affect anyway.

Any information would be greatly appreciated.

Thanks

View 10 Replies View Related

Migrating SSIS Packages To Production And Job Scheduling

Apr 10, 2006

I have migrated several (7) DTS packages to SSIS in a development environment. In this environment these packages all work as designed. I am now in the process of placing the .dtsx files on the production server and scheduling jobs around them.

I am encountering problems in 3 of these 7 packages. I get the following error:

Message
The job failed. The Job was invoked by User <domainuser>. The last step to run was step 1 (Create and Transfer Credentialling Data).
This is not what I would call very informative. I have opened the dtsx files in question in BIDS on the production server and each has the following error reported:

Error loading <name>dtsx; Failed to decrypt protected XML node "PassWord" with error 0x8009000B" Key not valid for use in specified state." You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.
I have looked at the package setting "Protection Level" and all seven packages have the same setting: EncryptSensisitveWithUserKey
Each of the connections within the packages have been defined to utilize Windows Authentictation. And the jobs are set to run under the SQL Agent Account.
What I find most puzzeling is that each of these packages are defined exactly the same and some work correctly and others do not.
Thanks for taking the time help me with this issue.

View 5 Replies View Related

Event Based Scheduling Of SSIS Packages

Sep 10, 2007

Hi,
Is it possible to do an event based scheduling of SSIS packages from SQL Server Agent? Like schedule a package to run when a file is available in a particular folder.
Does anyone have any similar experiences to share?

Regards,
Emil

View 1 Replies View Related

SQL 2012 :: Scheduling Packages Parallel And Retry On Failure

Jun 1, 2015

I come from other ETL tools (Oracle Warehouse Builder, BODI, BODS & DataStage) and i'm having trouble finding the best practice for scheduling a collection of packages to be processed parallel en retry those that fail. I created a staging project which contains all the packages (50) that extract data from 1 source system and grouped the packages into 2 sequence containers to make sure that the 'heavy' packages are started first and together in parallel.

I soon discovered that there is no standard option to have one child package retry on failure. Currently if 1 package fails the whole project is retried.
I explored checkpoints as a solution but that seems a dead end when running packages in parallel.

There seem to be 2 solutions for my issue:

(1) create a loop around every EPT with 3 variables (waittime, retry_counter & succes_flag)
(2) create an event handler to keep a list of ID's that failed and enable/disable EPT's based on that list (there's a lot more to it).

Option 1 seems like a lot of bloatware in what i expected to be standard functionality. I'm still investigating option 2.

How do others handle this kind of scheduling? Is it so different with SSIS that i'm approaching this incorrectly ?

View 0 Replies View Related

Package Configuration, Parent-child Packages And Job Scheduling

May 3, 2007

Hi,

I've found this problem that when I change settings in my configuration file it does not automatically apply to all child packages which uses the same configuration file if run from a job in SQL Server Agent. I need to open the package and save it again from BIDS. I use one "load group" package to execute all other packages.

Is there a way from the job configuration to set a setting so the package allways will have the newest configuration?

Regards
Simon

View 7 Replies View Related

Scheduling Job In Sql Server 2005

Apr 10, 2007

Hi,

I created a scheduled job in sql server 2005 which takes a daily backup of database.

My problem is this job does not run automatically.but when i execute it manually it runs on that instance.

do i need to activate any servrice to have scheduling of jobs running perfectly on my machine ?

Please guide me on this.

Thanks,

Prashant

View 1 Replies View Related

How To Scheduling A Query In Sql Server 2005

Apr 16, 2008

I want to schedule a query that ll insert a record in a table of the database at every 02:00 am. How should i do that. i am uisng sql server 2005?

Muhammad Saifullah

View 7 Replies View Related

Scheduling A Task In SQL Server 2005

Oct 10, 2007

I'm currently using Windows Task Scheduler to run a few jobs. We would like to start using the SQL Server Agent to handle this. The problem I am having is in specifing the 'working directory' of the program. The program is generating some files in a temp directory withing the root of the application. For some reason when I schedule in SQL it is generating these files in the WinSys32 directory.

I am using the CmdExec type in my job step.

I am sure I may have left out some info. please let me know if you need anything else.

thanks.

View 7 Replies View Related

Scheduling A Query To Be Executed At Given Time In SQL Server 2005

Apr 4, 2007

Hi friend!

I want to schedule a query or procedure running at given time regularly eg: at 12AM daily. Please tell me how to do that in sql server 2005.

We use SQL server 2005 developer edition.

Thanks in advance.

View 1 Replies View Related

Works Fine Inside BI Dev. Studio, But Fails When Scheduling It In SQL Server 2005.

Jul 13, 2005

Hi!

View 12 Replies View Related

SQL Server 2005 DTS Packages????????

Aug 25, 2006

How do you tranfer data between two SQL Server 2005 databases???? I swear I looked all over the place, but I don't see how it is done in SQL Server 2005.

View 4 Replies View Related

How To Deploy Packages To Sql Server 2005

May 22, 2006

I'm still getting used to SSIS and I'm wondering how to deploy all 20 of my ssis packages to my sql server 2005 machine in the msdb?

I could open each one and then save a copy as, but by default it doesn't put the name of the package in so I must copy and paste.

thanks.

View 4 Replies View Related

Running SSIS Packages In MS Server 2005

Jan 31, 2008

Hi
Just a brief question,
is there a way of displaying a success or not success message when running (testing) an SSIS package on SQL 2005 ?

Because i have to go through the steps to see if there was an error or not and for large SSIS packages this is a pain.

With DTS 2000 after it ran you got a message saying successfull or not, is there a way to activate this in SQL 2005 ?

I suppose i could just run the job ... but I prefer the other way as sometimes a job fail is a permissions problem, not a SQL/datapump task problem...

View 1 Replies View Related

MS SQL Server 2005 SP2 Problems With SSIS Packages

Mar 8, 2007

I installed SP2 to one of our servers to see what we'd need to do for our Production systems. The server in question is used for a log shipped copy of production, SSRS, SSIS and general duty stuff. I got errors in two areas during the installation -- 1 dealing with SSNS (don't use it yet on that server) and the second being the Client product.

After a reboot I went into a Business Studio solution I've been working on (and using) for several months. None of my packages are working--each having the following problem:

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'.
This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}'
failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))..

It seems to be in the designer as it is unable to display the the graphical version but it does let me switch to the code view.

What is the easiest way to troubleshoot and/or fix this?

View 6 Replies View Related

Sending Emails Throught DTS Packages In Sql Server 2005

Jan 23, 2007

Hai,
I am working on the DTS Package in SQL Server 2005 , actaully the DTA Packages Use OutLook to Send the email to the Mailing List , now that Out Look Stuff is not working Fine , soo I came to know that we can use Sp_send_dbMail stored Procedure insteds of Outlook , i am trying to do that my Email contains the attaachment to the Text file from the shared Folder.
I am not Getting the Correct Help when i am trying .
So can some one Helpe Providind Some examples and suggetions .

Thanks

View 1 Replies View Related

Converted Our DTS 2000 Packages To Sql Server 2005 SSIS

Nov 7, 2007

We are converted our DTS 2000 packages to Sql Server 2005 SSIS. I am getting following error on my ActiveX script that got converted. I am new to SSIS and DTS. Never ever worked with ActiveX also. So any help would be appreciated. Following is the script followed by error I get:

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim oPkg

SET oPkg = DTSGlobalVariables.Parent

SET stpBeginJob = oPkg.Steps("DTSStep_DTSActiveScriptTask_1")

SET stpFinishedJob = oPkg.Steps("DTSStep_DTSActiveScriptTask_3")

IF DTSGlobalVariables("Count").Value > 0 THEN

stpFinishedJob.DisableStep = True

stpBeginJob.ExecutionStatus = DTSStepExecStat_Waiting

ELSE

stpFinishedJob.DisableStep = False

stpFinishedJob.ExecutionStatus = DTSStepExecStat_Waiting

END IF

Main = DTSTaskExecResult_Success

End Function

Error I get Is:

[ActiveX Script Task] Error: Retrieving the file name for a component failed with error code 0x000A39BC.

Thank You

View 1 Replies View Related

Visual Studio 2008 And SQL Server 2005 SSIS Packages

Mar 3, 2008

My home machine has sql 2005 and Visual Studio 2005 installed. I uninstalled VS 2005 (RTM) and installed VS 2008 (RTM) in its place. I then found that the SSIS templates were missing. Lesson: don't uninstall VS 2005 if you want to use SSIS 2005!

1. Is there any "workaround" to this issue?

2. (If the answer to 1 is "No") I will install VS 2008 side-by-side with VS 2005 on the same box. When the SSIS issue is finally resolved, can I uninstall VS 2005 without doing damage to the VS 2008 install?

TIA,

Barkingdog

View 17 Replies View Related

Does The Sql Server 2005 EVAL Distribution Support Run Of Packages Under DtExec?

Mar 23, 2006

I believe I have made a complete install of Sql Server 2005 on my dev. machine, including all client tools, and can run SSIS packages from the dev. environment.

However DtExec refuses to run any package and always throws the "insufficient version" error (as does the "RunPackage" component, probably for the same reason).

I have repeatedly attempted to find something more to install from the Sql Server 2005 eval release that will allow DTExec to run without the "insufficient version" error, but can find nothing else to install from the eval. The install wizard (and the "change" wizard) indicates everything is installed and will not build a list of any additional components to install.

Are we sure that DtExec will install and run from a sql server 2005 eval distribution?

Licenses are in the pipeline (not that pipleine) but we need to start testing our SSIS solution in the meantime.

p.s. Kudos to the dev. team, it really is an excellent tool!

Thanks,

Ken

View 3 Replies View Related

Integration Services :: Remotely Execute Packages On SSIS Server - Packages Are Deployed In File System

Apr 22, 2015

We manage some SSIS servers, which has only SSIS and SSIS tools installed on them and not the sql server DB.

SSIS packages and configuration files are deployed on a NAS. We run the SSIS packages through DTEXEC by logging in to the server.

We want to allow developers to run their packages on their own on the server, but at the same time we dont want to give them physical access on the server i.e we do not want to add them into RDP users list on server properties. We want them to allow running their packages remotely on the server.

One way We could think of is by using powershell remoting and we are working on that. But is there any other way or any tool already present for the same.

View 4 Replies View Related

DTS Scheduling In SQL 2005

Nov 21, 2006

Hi all,

I am trying to create scheduled job for DTS. I have created new DTS in SQL 2005 but not able to create job out of it.

I tried creating Credential and then to create proxy with this:
Use master

CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomainmyWindowAccount', secret = 'WindowLoginPassword'

Use msdb

Sp_add_proxy @proxy_name='MyProxy', @credential_name='MyCredential'

Sp_grant_login_to_proxy @login_name=' devlogin', @proxy_name='MyProxy'

Sp_grant_proxy_to_subsystem @proxy_name='MyProxy', @subsystem_name='SSIS'

but could not get the job to schedule it. when i try to search for the DTS package(TestRev) it could not find it:

Is there a way that i can just call TSQL statement to run that dam DTS because it is too confusing to create job for DTS.

Thanks

View 7 Replies View Related

Scheduling 2005 Profiler

Jan 16, 2008

I want profiler to run for 5 minutes whenever the system cpu exceeds/reaches 80%. Is this possible?
TIA

View 1 Replies View Related

Scheduling Legacy DTS 2000 In Sql 2005

Sep 7, 2007

Hi Guys

There are a few dts packages in our sql server 2000 database which we schedule daily for at night for business purposes.

how can i schedule the same DTS packages in Legacy SQL 2000 DTS when we migrate the Databases across to Sql 2005.

Can that be done or we need to migrate the DTS Package to SSIS

Vic

View 1 Replies View Related

Execute A Stored Procedure Which Calls SSIS Packages Using A Proxy Account For Non Sysadmins In Sql Server 2005

Sep 18, 2007

Hi all,
I have a problem while i create a proxy account.The situation is like this...There is a user who has an login in to the server.He has a stored procedure which calls some on the SSIS packages and XP_cmdshell...so this stored procedure basically load some data in to the tables .So for the login in order to execute the stored procedure as he is not a Sys admin I have created a proxy account in my account as Iam an SA and then in the proxies and in principals I selected his login name and this way I have created a credential and a proxy account.

Now the problem is if he logins with his id and password and try to execute the stored procedure it gives an error message

Server: Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1
The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.

....so this mean the login is not able to see the proxy account.So what I did is I created a job and then in the job owner tab I have selected his login and then created a step with the type operating system (CmdExec) as I need to just execute the stored procedure and used the proxy account that I have created.

so I gave the command -- exec <stored procedure> --.
But this job fails and gives the error message as
[298] SQLServer Error: 536, Invalid length parameter passed to the SUBSTRING function. [SQLSTATE 42000]....

So now ....first My question is am I doing in a right way....if its right then why Iam not able to execute the stored procedure.

If there is any other way through which I can execute the stored procedure using a proxy account for the logins who are not sys admins....please do let me know.....

Thanks
Raja.V

View 2 Replies View Related

SQL 2005 Std And Scheduling Backups To Include Full, Diff., And Trans. Logs

Feb 28, 2008

Regarding backups.
The first available time to do a full backup is at 11:00pm which also applies to diff. backups.
How often does the trans. logs need a back up?

View 5 Replies View Related

DTS Packages In 2005

Sep 10, 2007

Folks:

I have successfully upgraded my SQL Server 2000 Databases SQL 2005. After the successful upgrade I also migrated all of my SQL 2000 DTS packages using SQL Management Studio -> Management -> Legacy. I can see all these DTS packages and I can also run these.

How can I OPEN these DTS Packages in SSIS (Business Intelligence) for me to make the changes? I am not able to open them and also not able to see them File->open. All these DTS packages are stored in MSDB database.

Thanks !

View 2 Replies View Related

Sql Server 2000 - Scheduling A Job?

Jul 11, 2006

I'm going to be creating a few triggers on tables to add new records to a seperate table (AlertData). Come 6pm or so I want a scheduled job to automaticaly run to make an HTTP wbe request to my SendAlerts.ASPX page. The page will simply make a database call for all users and the AlertData table contents, build what it needs and send out all the email alerts.
My question is is how do i create such a scheduled job under Sql Server 2000? It should run everyday at 6pm EST (even if the dbase server is restarted) and make an HTTP web request to my URL.
Thank you.

View 1 Replies View Related