Scheduling A Job! URGENT!
Aug 27, 2002I have 2 DTS packages. I want to schedule the 2nd one to excecute after the 1st one has executed. How do I schedule this in a job ?
Any suggestions are appreciated!
Danna
ADVERTISEMENT
Scheduling(URGENT... URGENT)
Dec 20, 2000Hi everybody,
I have a batch which needs to be run every day night at 2:00 am.I Using At command but it is not working. if u have idea, please let me know
I AM USING THE FOLLOWING COMMAND :
AT 2:00AM C:SCHED.BAT
Thanks in advance
Krishna
Timeout Expired -- URGENT, URGENT, URGENT!!!
Sep 27, 2000This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.
Please help!!!
URGENT.Sql Server Does Not Recognise MAPI , Or Profile Name URGENT
Oct 26, 2000hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
Urgent, Urgent !! My Sql Server Refused To Start Due To Encrypton
Mar 23, 2001Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.
Please help me to start sql server.
Thanks.
Michel
Urgent Urgent Please.(Access SQL Pass Through Queries)
Jul 6, 2000Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;
It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
Thank you very much for your concern.
Job Scheduling In Sql 7.0
May 30, 2002I have set a job to run hourly between 8 am and 8 pm. I mark the schedule as enabled and mark the job as enabled. It will run for that day and then the enable check on the schedule clears out. I have several other jobs that run without this problem. Has anyone heard of this before and can this be effectively monitored?
thanks, mary
Scheduling
Oct 16, 2001Hi,
Can anybody give me the steps to schedule Database backup and restores in 7.0?
I can do the backup and restores of the database without scheduling. I dont know how to do with scheduling.
Thanks in advnace.
Scheduling Of Job
Feb 15, 2001I've created a task which monitors the server, I want it to run every 30 sec.
But the scheduler in job allows to run at the most only 1 min. Is it the way to make it 30 sec?
Thanks.
Qinglee
Scheduling A DTS Job
Sep 13, 2000Does anyone know how to schedule a DTS job to collect data from another database?
cheers!
Job Scheduling
Sep 20, 2000Can I use SQL Server Agent schedule to start my.exe?
I am not sure in command that I have to place in "Edit Job Steps" DialogBox.
It's not working just with path.
DTS Scheduling
Aug 11, 1999Hello all,
I am trying to schedule DTS package. Seems like I have two options
1. Save DTS package as a File and Run it using dtsrun function
2. Save DTS package on server and use scheduling wizard
If I use method #1 it works fine but you have ti create job, schedule it
and yada, yada, yada.....
Method #2 seems mach more simple but then I use it it does nothind.
Am I missing something?
Thank you an advance.
Boris
DTS Scheduling
Jul 22, 1999I'm having a little trouble getting a DTS package to run as a scheduled event. I have created the same one(an export to Access db on the same computer) as a local package and a repository package. Both will run normally when I start them manually from the DTS screen, but they will not run from the scheduler. It seems like this might be some kind of permissions problem, but it could easily be something else, since I've never used DTS before.
Thanks
DTS Scheduling
Feb 21, 2001I created a DTS to transfer two tables from one server to another and set up a schedule to run once everyday. I could not get it to run. I got this warning message from evetlog:
SQL Server Scheduled Job 'Forum' (0x0E0AA96BB9A1654C94AA12CC8B854BC8) - Status: Failed - Invoked on: 2/21/2001 4:00:00 PM - Message: The job failed. The Job was invoked by Schedule 1 (Forum). The last step to run was step 1 (Forum).
But when I execute it manually, it run successfully.
I am using MS SQL 7.0
Your help is much appreciated.
Job Scheduling
May 19, 2002i'm very new to sql server and stuff... so i'm lost here.
i'm using the job scheduling wizard and i'm getting a couple of errors. first of all i need this vbscript to run weekly... do i need to translate it to tsql, or can i just paste this into the job scheduler thing?
-----------------------------------------------------------
dim strSQL, oConn, objRS
const adOpenDynamic = 2
const adLockOptimistic = 3
Set oConn = Server.CreateObject("ADODB.connection")
Set objRS = Server.CreateObject("ADODB.Recordset")
oConn = "my conn string with secure info you cant see :)"
strSQL = "SELECT BattleRD FROM BattleList"
objRS.Open strSQL, oConn, adOpenDynamic, adLockOptimistic
objRS.MoveFirst
While Not objRS.EOF
objRS("BattleRD")=objRS("BattleRD") + 1
objRS.Update
objRS.MoveNext
Wend
objRS.Close
Set objRS = Nothing
-----------------------------------------------------------
here are my errors in the job scheduler after selecting the dates...
error 229: execute permission denied on object 'sp_help_operator', database 'msdb', owner 'dbo'
and...
error 229: execute permission denied on object 'sp_help_targetserver', database 'msdb', owner 'dbo'
what am i doing wrong / what do i need to do?
thanks
Job Scheduling
Jan 29, 2004Hi,
I have two jobs scheduled on the Agent. Each job has ten steps. The next step is executed only if the previous suceeds.
I want Job 2 to execute only if Job 1 suceeds. How do I schedule that?
I was thinking that I can have the ten steps of Job 2 as steps (11 to 20) of Job 1 with each step executing after the previous one succeeds. If I do that then I can get rid of Job 2.
Let me know what approach you would advise.
Thanks
Job Scheduling
Jun 24, 2008I am trying to schedule a simple job to run a stored procedure in my database. The stored procedure runs perfectly when I do so manually, however when I ask a job to run it, it gives me the following error:
Access to the remote server is denied because the current security context is not trusted [SQLSTATE 42000](Error 15274).
The stored procedure does create a linked server (to an ORACLE database) and executes some commands across it. I've tried doing the link server creation as a separate step in the job and it executes that just fine so it has no issues creating the server, it just dies when it tries to use it. The job owner is the same user I've been using the execute the procedure manually. I also run the procedure step as that same user. But I still have this problem. Someone please help me!!
Job Scheduling
Oct 22, 2007Hi,
Is it possible to input values to a sql job so that the sam ejob runs for different parameters i.ee the same job runs for X on all 7 days o a week and for Y only on all weekdays...
Scheduling SQL Job
Nov 15, 2007My boss wants to schedule a job that will run on the Wednesday night before the first Thursday of every month, recur on the first Thursday, and again on the Friday, Saturday, Sunday and Monday following the first Thursday of the month.
I've already got the first Thursday scheduled. Is there a way to schedule the other days. I haven't been able to find any documentation on how to do it, if it is possible. And I've looked at the sp_add_jobschedule to noavail.
Any help would be much appreciated. Even if it is telling me it can't be done.
Thanks
Scheduling Bug?
Dec 20, 2006Hi!
I'm trying to create a subsciption for my report. In first creation I can do scheduling just fine, but when I try to edit my schedule, it's totally different. It shows value 1.1.0001 and when I try to change it, it's gives me first message:
value of '1.1.0001 0:00:00' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'. Parameter name: Value (System.Windows.Forms)
and after that when pushing OK it gives me message: "The required field StartDateTime is missing from the input structure. (rsMissingElement)".
Do you think it's a bug or is there something which I'm doing wrong?
Tero Kruth
Scheduling With SQL Databases.
Feb 22, 2007I know enough about Databases to get myself in trouple. So maybe someone can point me in the right direction, or help me out. I work for the American Red Cross in Provo UT. We want to be able to put class registration on line so that someone can visit our website chose the class they want to take, register and pay for it all on-line. Our website http://www.redcrossut.org is hosted with godaddy and I am able to post a SQL Database. I know that our website as it stands is very poor. The people who have maintained it in the past have no idea what they were doing, my job is not the website, I am over Health & Safety Training, but have done some work with websites for fun in the past. I know a little about Visual Studio and plan to rebuild the site using C#. I can build a basic Database and interface to it with Visual Studio, Godaddy can help me with the payment part, but I have no idea how to set up SQL to allow scheduling. Any help would be appreciated. Even if it’s just a link to a tutorial.
Ed Hall
Director Health & Safety Services
Mountain Valley Chapter
American Red Cross
Scheduling A Task Using DTS
Sep 20, 2005Hey Guys!
I have a SQL Update Query that I want to run automatically everyday and
I have read through the posts and I do not understand very clearly how
to go about creating one.
The SQL query I want to run is this:
UPDATE Rental
SET TotalFee = ExtraFee + TotalFee
WHERE DaysOverdue >= 0
Once I have made a DTS package. How do I declare it in my coding???
Thanks in advance!
Manual Job Scheduling
Aug 30, 2002We are using an MSDE database engine (1.0=sql7) as a report scheduler on a web server. I can access MSDE via SQL7 Enterprise Manager to connect and view MSDE, but cannot use the DTS and job scheduling as MSDE seems to lack needed components. Using Microsoft Knowledge Base article Q241397 as a guide, I was able to create a backup of the msdb database using stored procedures including sp_add_job, sp_add_jobserver,etc, that are already present in the msdb database.
My problem is that I need to create and schedule a job for another MSDE database called CE8. This database was created by the reporting app, and contains no stored procedures. It looks to me like only msdb has the needed job scheduling procs. Does this imply that I am supposed to schedule all jobs for all databases via msdb database, or will I need to copy all job scheduling stored procedures into the other CE8 database, then create a job? Hope this makes sense,
Randy
DTS Scheduling Problem
Mar 30, 2001Does anyone else ever have a problem getting scheduled DTS packages to run? I have a package that is replicating from an Access database. If I manually execute the DTS package, it works fine. If I try to schedule the same package, it bombs. Also what password do you use for the Owner and User when you are trying to schedule a SQL Server (not repository) DTS package? I've tried my loging password and it I still get problems.
View 3 Replies View RelatedScheduling A DTS Package
Apr 6, 2001I have created a DTS Package which collects data from DB2 and stores in a table on SQL Server v 7.0. The execution of the package works fine.
When I schedule the package by right-clicking and selecting SCHEDULE PACKAGE,
I fill in the dialog box. When the package runs, I receive the following error:
DTSRun: Loading... Error: -2147217390 (80041012); Provider Error: 0 (0) Error string: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()). Error source: Help file: Help context: 0. Process Exit Code 1. The step failed.
I get this same error when I run the package as a job.
The package is in the repository. My run command looks like:
DTSRun /S 111.11.11.11 /U sa /P xxxx /N DTS_Projections /R
The package owner is sa.
Can anyone offer any advise
Dts Scheduling Problem. Help!!!!!!!!!!!
May 29, 2001I have a Dts Package that runs no problem but if I schedule it I get this Error:
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217887 (80040E21) Error string: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217887 (80040E21); Provider Error: 0 (0) Error string: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Problems With DTS Scheduling?
Jul 2, 2001Hey all,
Did anyone run in to problems with the DTS scheduler function? IE. How do I check whether a DTS package was run or not? How do I check what the schedule'd properties are (ie. for what date, for what month, etc..)?
Ilya
DTS Scheduling Issues
Jul 26, 2001This is kind of a hybrid issue. When I or my developers create DTS packages we can usually run them fine from our machines, but when we go to schedule them, or run them from the Server Client we get an error that the package cannot be found. I realize that this must be some time of permissions or owner issue, but I don't know where to start looking. Should all of my DTS packages be owned by the SQL Agent Account? What am I overlooking?
View 8 Replies View RelatedDTS Scheduling Problem
Aug 7, 2001I created the SIX differnt DTS packages and calling them one by one in another DTS. The active script (VB SCRIPT CODE) is given as flllows:
'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Function Main()
Dim oPackage1
Dim oPackage2
Dim oPackage3
Dim oPackage4
Dim oPackage5
Dim oPackage6
Set oPackage1 = CreateObject ("DTS.Package")
oPackage1.LoadFromSQLSERVER "ENG","sa","password",,,,,"FILE CREATION"
oPackage1.EXECUTE
Set oPackage2 = CreateObject ("DTS.Package")
oPackage2.LoadFromSQLSERVER "ENG","sa","password",,,,,"DELETE THE FOLDER"
oPackage2.EXECUTE
Set oPackage3 = CreateObject ("DTS.Package")
oPackage3.LoadFromSQLSERVER "ENG","sa","password",,,,,"Query on the Fly"
oPackage3.EXECUTE
Set oPackage4 = CreateObject ("DTS.Package")
oPackage4.LoadFromSQLSERVER "ENG","sa","password",,,,,"New to EXCEL"
oPackage4.EXECUTE
Set oPackage5 = CreateObject ("DTS.Package")
oPackage5.LoadFromSQLSERVER "ENG","sa","password",,,,,"Sending the Eccel file as an attachment"
oPackage5.EXECUTE
Set oPackage6 = CreateObject ("DTS.Package")
oPackage6.LoadFromSQLSERVER "ENG","sa","password",,,,,"Delete and Recreate the FOLDER ECCEL"
oPackage6.EXECUTE
Set oPackage1=Nothing
Set oPackage2=Nothing
Set oPackage3=Nothing
Set oPackage4=Nothing
Set oPackage5=Nothing
Set oPackage6=Nothing
Main = DTSTaskExecResult_Success
End Function
+++++++
Basicllay I included a no. of SUCCESS and FAILURE messages within every package. When a package compeltes, it sends an email to the ADMIN. for notifying the compeletion of TASK. I am using OUTLOOK 2000 mail client POP3/SMTP.
When I run manually the above mentioned active script. It works very fine but when I schedule it, it FAILS and windows NT EVENT VIEWER (Application Log) reports the following error message:
"Your profile was not successfully loaded, but you have been logged on with the default system profile. Please correct the problem and log off. (5)"
Source = USERENV
I treid to configure the SQL MAIL as well but unfortunately I am using OUTLOOK 2000 not excahnge, and documentation of SQL as well as the knowldge base of SWYNK say to configure the user profile but I did not find any anything even in address book to configure a user profile.
IS THERE ANYBODY WHO CAN HELP ME TO FIGURE OUT THIS SCHEDULING PROBLEM.
Thanks
Viv
DTS Scheduling Problem
Sep 24, 2001I had this problem a while ago, and in an effort to clean up Logins and Permissions, have created it again. Unfortunately, I didn't document what I did the first time to resolve this issue. I know it is a security issue, but I don't remember what permissions to add to what login to make this work.
When I create a DTS package (in Local Packages) and go to schedule it, I get this error.
Microsoft SQL-DMO (ODBC SQL State: 42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I'm assuming it's an issue with either the SQL Server Agent Service startup account (which has it's own login defined for it), or the SQL Server connection (which is using another SQL Server authentication login).
Thanks,
Jennifer
Job Scheduling For Backups
Oct 22, 2001When we run the backup job manually or schedule it, it gives us this error some times and fails:
Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed. [SQLSTATE 42000] (Error 3023) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
what exactly is the problem i don't understand ..there is no online help regarding either error 3023 or 3013..could you look into this please.
Thanks in advance for your help..
Radhika
Scheduling Backups With SQL 7
Nov 7, 2000Hello there,
I have recently been thrown into SQL with not much experience, and assigned the task of automating bacckups. I need to figure out how to get SQL to backup twice daily (with different file names).
When atempting to run the schedule backup, I could not find any information to help me on this. Does anyone know of any good books on the subject, or even better yet does anyone have relevant experience?
Thanks.
Scheduling A DTS Package
Aug 1, 2000Can I call a DTS package from server1 to run on server2 if the package is on server1?
Does the package have to be on both servers? Both databases are identical.
And if not, how do I script the DTS package on server1 to be used and created on server2?
I would appreciate your help.
Thanks,
Dianne