This table lists all the scheduled jobs (accessible via the "at" command) of NT servers.
|
Field name |
Data type |
Description |
|
id_snapshot |
number |
snapshots auto-numbering |
|
server_name |
string |
Netbios name of the server (without the two backslashes). |
|
command |
string |
String describing the command to be executed at the specified time. |
|
jobid |
number |
Identifier used by the scheduler service. |
|
hour_run |
string |
Specifies the command executing time (HH:MM format). |
|
flags |
number |
Bit mask describing the properties of the scheduler job (see Appendix 1). |
|
days_of_month |
string |
String listing the days of the month the command should be executed. |
|
days_of_week |
string |
String listing the days of the week the command should be executed. |
Following are the values used for the flags field bit mask:
|
Symbolic constant |
Value |
Meaning |
|
JOB_RUN_PERIODICALLY |
0x00000001 |
This flag bit is equal to the original value of this flag bit when a job was submitted. |
|
JOB_RUNS_TODAY |
0x00000004 |
This flag bit is set if JobId is larger than the current time of day of the computer from which this job is queued . |
|
JOB_EXEC_ERROR |
0x00000002 |
This flag bit is set whenever the Schedule service failed to execute successfully this job the last time this job was supposed to run. |
To list the jobs running each Monday, the following SQL query may be used:
SELECT * FROM jobs WHERE days_of_week LIKE '%Monday%'