August 12, 2008 at 6:46 am
Hi,
I have a scheduled job in sql server 2005. When i come in the morning i don't get any errors for this job. Bur i see that the job had not been done. So i run the same job by hand and it works.
I can't understand why it does not work on the scheduled time.
Any ideas?
Thanks.
August 12, 2008 at 6:59 am
What type of job are you executing? Is it writing a file? Is it a maintenance job (index rebuild, etc.)? What type of error is being logged for the job? Sounds like permissions but we need more information to be of any help.
-- You can't be late until you show up.
August 12, 2008 at 7:05 am
is the job and/or schedule active? is the schedule's start date in the past or in the future? is sql agent running?
August 12, 2008 at 7:12 am
First im sorry job is working on SQL Server 2000.
Actually im running a DTS package between 2 servers(i call them A and B). DTS has 2 steps. First step copying data from a database on B to another database on A. The second step Deleting data from the database on B.
1) B.database ------> A.database
2) Delete tables on B.database
It does not give any errors it shows that the job had been run successfully. But when i look i see the data has not been deleted. If i run it by clicking right and saying "start job at step", it works.
August 12, 2008 at 7:16 am
just out of curiosity, in your first post, you said the job had not been done. in your last post, you said the job ran successfully. how do you know it ran, and are you saying that it ran but didn't do any work?
August 12, 2008 at 7:16 am
Right click on the job under SQL Server Agent->Jobs. Then view history and check the "show step details" box. Highlight the failing step. It should provide more detailed info as to what is failing, and maybe why.
Did you check the SQL Server logs?
-edit - TYPO..
-- You can't be late until you show up.
August 12, 2008 at 7:52 am
sorry i couldn't explain well.
I have only one step for the job. "DTS run" step .....
the 2 steps are in my DTS package. When i run the DTS it works and it deletes the data on server B. And when i run the job which makes run the DTS by clicking right "start job" or "start job at step" it works and deletes data on B also.(job is working on A)
i schedule the job, it runs and when i look to history i see the message that the step succeeded and on step details i get this message :
Message
Executed as user: xxx. ... TSStep_DTSTransferObjectsTask_1 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Logins; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Users; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0... Process Exit Code 0. The step succeeded.
But when i look to database on the server B i see that the data not been deleted.
When i run it by hand i get the same message :
Executed as user: xxx ...TSStep_DTSTransferObjectsTask_1 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Logins; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Users; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0... Process Exit Code 0. The step succeeded.
The only difference between two conditions ; data is not deleted on server B when the job is scheduled. On the sql logs i don't see any errors either. So i can't understand why.
it is a really interesting condition and i see it the firs time.
thanks if you have any ideas.
August 12, 2008 at 8:07 am
I don't see anything in the logs but I suspect permissions. Does the account running SQL server agent have appropriate rights to serverB? Trying logging into serverB using the agent login and see if you are able. If so, try and manually deleting the same tables with that login.
-- You can't be late until you show up.
August 14, 2008 at 3:11 am
Hi,
I'm sorry occupying you with that problem, actually i found the solution. So i write it may be someone will need it.
When i run the job by hand it runs on my computer, and when i schedule it on the server it runs on the server. On the server A i have linked the sever B and when i looked the properties(server options) the linked server i saw that "rpc" and "rpc out" were false.
I changed them true so it worked.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply