Re: Scheduled tasks on cluster?
- From: "Chuck Timon [Microsoft]" <ctimon@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 08:01:45 -0500
Try this -
1. Go into HKLM\SYSTEM\CURRENTCONTROLSET\SERVICES and write down the exact
name of the service as it shows in the list as you will need this for later.
In this case it will be Schedule.
2. Go into Cluster Administrator and highlight the group you want to put
this in.
3. Right click on the group and choose NEW and RESOURCE
4. In the NAME box, input whatever you want shown in Cluster Administrator
5. In the Description box, put whatever you want if anything
7. In the RESOURCE TYPE field, choose GENERIC SERVICE
8. In the Group field, it should already have the group you want.
9. select Next button
10. Make sure that both the nodes are listed as Possible Nodes and choose
Next
11. For dependencies, I would go ahead and list the Disk and the Network
Name as
dependencies and choose Next
NOTE: The Task Scheduler Generic resource must also be setup with a
dependency on
the physical disk and network name to prevent the resource from starting
before the
other resources are online.
12. For the Service Name field, input exactly what you wrote above for the
name of the Service. If it does not identically match, the service will
fail to come online.
13. For the Startup Parameters, you would normally leave this blank. If the
Service requires any parameters, it is generally in the registry for the
service.
Schedule uses Svchost to start so the following parameters are required:
%SystemRoot%\System32\svchost.exe -k netsvcs
14. Go ahead and select the "Use Network Name" box and choose Next
15. For the registry key, go ahead and add the complete exact path to the
registry. HKEY_LOCAL_MACHINE is a given, so you would use:
SOFTWARE\Microsoft\SchedulingAgent
A. The scheduled job information is located in c:\%systemroot%\tasks
subdirectory.
- create a tasks directory on the shared disk
B. Modify the following registry key so that the tasksfolder location is
pointed
to the tasks subdirectory on the shared disk.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SchedulingAgent
This key has the following value: TasksFolder reg_expand_sz
%SystemRoot%\Tasks (change this path to task directory on the shared disk)
C. Add "software\microsoft\schedulingagent" (minus the quotes) to the
Registry
Replication tab for the generic service properties.
NOTE: There may be an issue performing the work and test from a terminal
server
session as the jobs may initially fail. Log off and back on terminal server
(see
Q232276) and then the jobs worked ok.
NOTE: The security credentials for each job are contained in the Protected
Storage Database on the local node and not with the job. So in order for a
job to work on both nodes we need to refresh the credentials of the job on
each node. To do that, create the job on first node, set the credentials.
Move the generic service resource to the 2nd node and enter the credentials
for the job again. This issue is discussed in the following KB: Q317529 -
Scheduled Task Does Not Run When You Push It to Another Computer.
16. Choose Finish and it is created. You can bring the resource online at
this point.
--
Chuck Timon, Jr.
Microsoft Corporation
Longhorn Readiness Team
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EC95C1A0-D85C-4299-8654-A7444B183460@xxxxxxxxxxxxxxxx
That doesn't make sense to me. If I connect to the cluster name and
create a
scheduled task and then failover the cluster the task is no longer there.
I'd have to have the task created on both nodes in order for it to work.
Am
I missing something?
Dan
"Ryan Sokolowski [MVP]" wrote:
Dan,
Connect to your failover cluster instance (the "virtual cluster name")
and
create your scheduled task from there....no need to duplicate the task on
multiple nodes.
For example, if your cluster name is MSSQLCLUSTER1, you would go Start,
Run,
\\MSSQLCLUSTER1 and you'll see the Scheduled Tasks link there...
--
Ryan Sokolowski
MVP - Windows Server - Clustering
MCSE, CCNA, CCDA, BCFP
Clustering101.com - Coming Soon!
This posting is provided "AS IS" with no warranties, and confers no
rights.
"Dan" <Dan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D8D35E45-EF23-4135-816B-C8246BE96E05@xxxxxxxxxxxxxxxx
If I want to have scheduled tasks run scripts against a drive that is
shared
storage on a cluster is that possible? My fear is that if I set
scheduled
tasks on both nodes that the passive node will fail everytime because
it
will
not own the storage resource. Is there some type of scheduled task
resource
I'm missing?
.
- References:
- Re: Scheduled tasks on cluster?
- From: Ryan Sokolowski [MVP]
- Re: Scheduled tasks on cluster?
- Prev by Date: Re: Oracle10g on Windows 2003 Cluster
- Next by Date: Re: Scheduled tasks on cluster?
- Previous by thread: Re: Scheduled tasks on cluster?
- Next by thread: Re: Oracle10g on Windows 2003 Cluster
- Index(es):