Deleting SQL Packages

I have been trying to get this CL that I created to run at night but it keeps ending abnormally. If it run it manually during the day, it runs fine and deletes the SQL packages that don't have locks on them. Do I need to do something different at night, like end the subsystems?

Thanks
Stephanie

Stephanie,

Do you have the error that is generated. You should not need to do anything different, assuming that you are running the program via a standard CALL.

Some things to check would be that the job that runs at night is using the same user profile as you run with during the day. Also ensure that your program handles the failures if the object is in use (locked).

Hope this helps.

Tom Davidson

Tom,

I set the job up in Robot to run 1 hour before our weekly backup. Since I
haven't gotten it to work right, I changed it to run every night and to send
a message to me after it deletes every sql package. I don't get an error
message. I have a MONMSG statement looking for CPF2125 and CPF2117. I have
attached the CL that I wrote. It is possible that submitting it through
Robot, Robot might not have enough authority to run job. We are currently
on XE and I don't want to set the job up in Sleeper since eventually I will
have to change it when we go off of World.

Thanks for the suggestions, I will look into them.
Stephanie




Stephanie Stroh
William Grant & Sons, Inc
Edison, NJ

Re: RE: Deleting SQL Packages

Stephanie,

If you go to the ROBOT job setup screen (5?) you can change the user id the jub runs under. This may solve the problem.

Note: I don't see the attachment.

Tom Davidson