Toad World® Forums

automation designer scheduler

Hi,

I am trying to schedule a simple app that runs a sql script, outputs to an excel spreadsheet and then emails it. The job runs fine manually, however when I attempt to schedule the app I get the following message:

Error Registering Task

Reason: The referenced account is currently locked out and may not be logged on to.

I do not know what account this is referring to. The Oracle account used for the sql statement is not locked nor is my windows account.

Help.

Sam
error.png

This error looks like it’s coming from windows task scheduler. I would recommend going to your windows task scheduler outside of Toad and trying to create
a similar task. This should give us a clue.

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:27 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] automation designer scheduler

automation designer scheduler

Thread created by sam.powell71026

Hi,

I am trying to schedule a simple app that runs a sql script, outputs to an excel spreadsheet and then emails it. The job runs fine manually, however when I attempt
to schedule the app I get the following message:

Error Registering Task

Reason: The referenced account is currently locked out and may not be logged on to.

I do not know what account this is referring to. The Oracle account used for the sql statement is not locked nor is my windows account.

Help.

Sam

Attachments:

error.PNG

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hi Sam,

This error is returned by Windows when the task is registered. As Brad mentioned below, try creating the task outside of Toad – I expect it will most likely
fail.

If it doesn’t, based on a quick Google search, there are a number of reasons why this might happen. One reason might be that the SID being returned when authenticating
the Windows log in for the task is returned as “Nobody”. The following link talks about this issue, what causes it, and what you might need to do on the server to fix it.

http://social.technet.microsoft.com/Forums/windows/en-US/f8304099-d0bd-43dd-b0ec-6dfb4362ff44/the-referenced-account-is-currently-locked-out-and-may-not-be-logged-on-to?forum=w7itprosecurity

Another reason might be an issue with the options selected for running the task in Windows Vista and higher. The following is a MS hotfix that might help to
address this issue.

http://support.microsoft.com/kb/2548120

If you still run into issues with this, let us know what options you’re selecting when trying to save the task.

-John

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:27 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] automation designer scheduler

automation designer scheduler

Thread created by sam.powell71026

Hi,

I am trying to schedule a simple app that runs a sql script, outputs to an excel spreadsheet and then emails it. The job runs fine manually, however when I attempt
to schedule the app I get the following message:

Error Registering Task

Reason: The referenced account is currently locked out and may not be logged on to.

I do not know what account this is referring to. The Oracle account used for the sql statement is not locked nor is my windows account.

Help.

Sam

Attachments:

error.PNG

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thanks for the quick responses.

I tried creating a task in windoze and it too errored. I opened a ticket with our windoze support team.

I’ll update when I have more information.

Sam

From: John Bowman [mailto:bounce-jbowman@toadworld.com]

Sent: Wednesday, October 01, 2014 11:52 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] automation designer scheduler

RE: automation designer scheduler

Reply by John Bowman

Hi Sam,

This error is returned by Windows when the task is registered. As Brad mentioned below, try creating the task outside of Toad – I expect it will most likely
fail.

If it doesn’t, based on a quick Google search, there are a number of reasons why this might happen. One reason might be that the SID being returned when authenticating
the Windows log in for the task is returned as “Nobody”. The following link talks about this issue, what causes it, and what you might need to do on the server to fix it.

http://social.technet.microsoft.com/Forums/windows/en-US/f8304099-d0bd-43dd-b0ec-6dfb4362ff44/the-referenced-account-is-currently-locked-out-and-may-not-be-logged-on-to?forum=w7itprosecurity

Another reason might be an issue with the options selected for running the task in Windows Vista and higher. The following is a MS hotfix that might help to
address this issue.

http://support.microsoft.com/kb/2548120

If you still run into issues with this, let us know what options you’re selecting when trying to save the task.

-John

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:27 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] automation designer scheduler

automation designer scheduler

Thread created by sam.powell71026

Hi,

I am trying to schedule a simple app that runs a sql script, outputs to an excel spreadsheet and then emails it. The job runs fine manually, however when I attempt
to schedule the app I get the following message:

Error Registering Task

Reason: The referenced account is currently locked out and may not be logged on to.

I do not know what account this is referring to. The Oracle account used for the sql statement is not locked nor is my windows account.

Help.

Sam

Attachments:

error.PNG

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error, you may not disseminate, distribute or copy this e-mail or any attached files. Please
notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are not the intended recipient or if you received this e-mail in error, you are hereby notified
that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.

Other than the time to start, I tried the “run only when logged on” and run whether user is logged on or not” . both give the same error.

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:58 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] automation designer scheduler

RE: automation designer scheduler

Reply by sam.powell71026

Thanks for the quick responses.

I tried creating a task in windoze and it too errored. I opened a ticket with our windoze support team.

I’ll update when I have more information.

Sam

From: John Bowman [mailto:bounce-jbowman@toadworld.com]

Sent: Wednesday, October 01, 2014 11:52 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] automation designer scheduler

RE: automation designer scheduler

Reply by John Bowman

Hi Sam,

This error is returned by Windows when the task is registered. As Brad mentioned below, try creating the task outside of Toad – I expect it will most likely
fail.

If it doesn’t, based on a quick Google search, there are a number of reasons why this might happen. One reason might be that the SID being returned when authenticating
the Windows log in for the task is returned as “Nobody”. The following link talks about this issue, what causes it, and what you might need to do on the server to fix it.

http://social.technet.microsoft.com/Forums/windows/en-US/f8304099-d0bd-43dd-b0ec-6dfb4362ff44/the-referenced-account-is-currently-locked-out-and-may-not-be-logged-on-to?forum=w7itprosecurity

Another reason might be an issue with the options selected for running the task in Windows Vista and higher. The following is a MS hotfix that might help to
address this issue.

http://support.microsoft.com/kb/2548120

If you still run into issues with this, let us know what options you’re selecting when trying to save the task.

-John

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:27 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] automation designer scheduler

automation designer scheduler

Thread created by sam.powell71026

Hi,

I am trying to schedule a simple app that runs a sql script, outputs to an excel spreadsheet and then emails it. The job runs fine manually, however when I attempt
to schedule the app I get the following message:

Error Registering Task

Reason: The referenced account is currently locked out and may not be logged on to.

I do not know what account this is referring to. The Oracle account used for the sql statement is not locked nor is my windows account.

Help.

Sam

Attachments:

error.PNG

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error,
you may not disseminate, distribute or copy this e-mail or any attached files. Please notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are
not the intended recipient or if you received this e-mail in error, you are hereby notified that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error, you may not disseminate, distribute or copy this e-mail or any attached files. Please
notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are not the intended recipient or if you received this e-mail in error, you are hereby notified
that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.

I created a batch file to run the sql script and scheduled it through the windows task scheduler. It worked fine. Our helpdesk says you can’t send an email
from a scheduled task. I removed the email action from the job, but I still cannot create a schedule from automation designer.

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 4:32 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] automation designer scheduler

RE: automation designer scheduler

Reply by sam.powell71026

Other than the time to start, I tried the “run only when logged on” and run whether user is logged on or not” . both give the same error.

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:58 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] automation designer scheduler

RE: automation designer scheduler

Reply by sam.powell71026

Thanks for the quick responses.

I tried creating a task in windoze and it too errored. I opened a ticket with our windoze support team.

I’ll update when I have more information.

Sam

From: John Bowman [mailto:bounce-jbowman@toadworld.com]

Sent: Wednesday, October 01, 2014 11:52 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] automation designer scheduler

RE: automation designer scheduler

Reply by John Bowman

Hi Sam,

This error is returned by Windows when the task is registered. As Brad mentioned below, try creating the task outside of Toad – I expect it will most likely
fail.

If it doesn’t, based on a quick Google search, there are a number of reasons why this might happen. One reason might be that the SID being returned when authenticating
the Windows log in for the task is returned as “Nobody”. The following link talks about this issue, what causes it, and what you might need to do on the server to fix it.

http://social.technet.microsoft.com/Forums/windows/en-US/f8304099-d0bd-43dd-b0ec-6dfb4362ff44/the-referenced-account-is-currently-locked-out-and-may-not-be-logged-on-to?forum=w7itprosecurity

Another reason might be an issue with the options selected for running the task in Windows Vista and higher. The following is a MS hotfix that might help to
address this issue.

http://support.microsoft.com/kb/2548120

If you still run into issues with this, let us know what options you’re selecting when trying to save the task.

-John

From: sam.powell71026 [mailto:bounce-sampowell71026@toadworld.com]

Sent: Wednesday, October 01, 2014 11:27 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] automation designer scheduler

automation designer scheduler

Thread created by sam.powell71026

Hi,

I am trying to schedule a simple app that runs a sql script, outputs to an excel spreadsheet and then emails it. The job runs fine manually, however when I attempt
to schedule the app I get the following message:

Error Registering Task

Reason: The referenced account is currently locked out and may not be logged on to.

I do not know what account this is referring to. The Oracle account used for the sql statement is not locked nor is my windows account.

Help.

Sam

Attachments:

error.PNG

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error,
you may not disseminate, distribute or copy this e-mail or any attached files. Please notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are
not the intended recipient or if you received this e-mail in error, you are hereby notified that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error,
you may not disseminate, distribute or copy this e-mail or any attached files. Please notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are
not the intended recipient or if you received this e-mail in error, you are hereby notified that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

This e-mail and any files transmitted with it contain confidential and proprietary information. If you are not the intended recipient, or if you received this e-mail in error, you may not disseminate, distribute or copy this e-mail or any attached files. Please
notify the sender immediately by e-mail that you received this e-mail by mistake, then delete it and all attached files from your system and destroy all copies. If you are not the intended recipient or if you received this e-mail in error, you are hereby notified
that disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail or attached files is strictly prohibited.

I’m having the same problem. Anyone found the solution to this?