Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The New Trigger dialog window offers you two options on the Begin the task fieldTo create a trigger for your task, you can define triggers that are based on time or specific events such as:

  • On a schedule - use this option to create a trigger based on a scheduled criteria.
  • At log on  - select this option to run the task when a user logs on to the computer.
  • At startup - use this option to run the task when the computer starts up.
  • On Idle - select this option to run the task after the computer enters an idle state.
  • On an event - use this option to run the task when specific event entries are added to an event log.
  • At task creation/modification   - select this option if you want to run the task as soon as it is created or when the task is modified. 
  • On connection to user session - use this option to run the task when a user session is connected to the local computer or from a remote desktop connection.
  • On disconnect from user session - select this option to run the task when a user session is disconnected from the local computer or from a remote desktop connection.
  • On workstation lock - use this option to run the task when the computer is locked.
  • On workstation unlock  - use this option to run the task when the computer is unlocked. 

Specific settings are defined for each option. Go to the respective sections below to view these options. 

Creating a Trigger On a Schedule

If you select this option, you can select from one of the following drop-down options from the the Setting occurs field field

  • One Time -  use this option to run the task once at a specific date and time.
  • Daily - use this option to run the task once per day every X number of days (Recurs every every option). For example, you can specify to run a task every 2 or 3 days. 
  • Weekly - use this option to run the task in certain days of the week every X number of weeks (Recurs every option). For example, you can specify to run a task each Sunday and Wednesday every three weeks.
  • Monthly - use this option to identify specific dates of certain months according to these options:
    • Day of every month(s) - select a specific date in a month in which you want to run the task. For example, you can define to run a task the 12th of January. 
    • The of every month(s) - use this option when you do not want to determine specific dates. You can select from options such as FirstSecondThirdFourth, or Last of a selected week day of a specific month. For example, you can determine to run a task the Second Sunday of March.
Tip

Use the option Synchronize across time zones to make the time relative to UTC (Coordinated Universal Time) instead of the computer time zone that runs the task. Use this setting when you want to run tasks simultaneously in multiple time zones. 

After you select your trigger time-based specifications, go to to Advanced Settings for  for more trigger options. 

Creating a Trigger

...

at Log on 

Use this option if you want the task to run when a user logs on to the computer. You can select from:  

  • Any userUser - use this option to run the task when any user logs on to the computer.
  • Specify userSpecified User -  use this option to determine a specific user that will trigger the task.

Creating a Trigger

...

at Startup

Select this option if you want to run the task when the computer starts up. 

Creating a Trigger On idle 

Select this option to run the task after the computer enters an idle state. You can set the idle settings in the Conditions tab of  tab of this wizard. 

Creating a Trigger On an Event

Use this option if you want to identify specific event entries added to an event log that will cause to run the task. You can select from:  

  • Basic - this option lets you define basic event trigger settings. Select from the Log drop down list, Log - displays a drop down list with different logs. Choose the log that contains the event, identify your event.
  • Source - displays the publisher name from the Source drop. Identify it from the drop-down list, and specify the event identifier in the Event ID field.  
  • Custom -  select this option if you want to customize your event trigger settings. Click New Event Filter to specify your settings. In the new dialog window you can define:
    • Filter - use this option to specify a custom event filter to query for events that will trigger the task. You can define the Logged parameter, the Event level (warning, critical, etc.), if the event will be filtered By Log or By source. In each case, specify the respective parameters. According to your settings, you can also identify, the Event IDs to Include or Exclude, Task CategoryKeywordsUsers, or Computers.
    • XML - an XML file will be created according to your settings in the Filter section, you can select Edit query manually to edit your query. 

...

  • Event ID - specify the event identifier in the field.

Creating a Trigger at Task Creation/Modification

Select this option if you want to run the task as soon as it is created or when the task is modified. If you select this option you do not need additional settings, but you can configure configure Advanced Options.

Creating a Trigger On

...

Connection to

...

User Session

Use this option run a task when a user session connects from a local or remote desktop connection. You can specify the following settings:

  • Any userUser - use this option to run the task when any user connects connects. Specific
  • Specifed User - select this option to specify the user that will cause the task to run run. 
  • Connection from remote computer - use this option to run the task when the user connects from a Remote Desktop Connection program from a remote computer.
  • Connection from local computer - use this option to run the task when the user connects to a user session on the local computer computer. 

Creating a Trigger On

...

Disconnect from

...

User Session

Use this option run a task when a user session disconnects from a local or remote desktop connection. You can specify the following settings:

  • Any userUser - use this option to run the task when any user disconnects disconnects.Specific
  • Specified User - select this option to specify the disconnected user that will cause the task to run run.
  • Connection from remote computer - use this option to run the task when the user disconnects from a Remote Desktop Connection program from a remote computer.
  • Connection from local computer - use this option to run the task when the user disconnects from a user session on the local computer computer.

Creating a Trigger On

...

Workstation Lock

Select this option to run a task when the computer is locked. You can specify from the following options:

  • Any user - use this option to run the task when any user locks the computer.
  • Specific Specified User - select this option to specify the user that will cause the task to run  run.  

Creating a Trigger On

...

Workstation Unlock

 Select this option to run a task when the computer is unlocked. You can specify from the following options:

  • Any userUser - use this option to run the task when any user unlocks the computer.
  • Specific Specified User - select this option to specify the user that will cause the task to run   .


Scroll pdf ignore
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...