Thanks a lot for your answers.
I will analyze and do my tests.
I'm using Bacula Community version 9.6.7 with PostgreSQL, and in the
database I found a 'status' table with the following data:
|jobstatus|jobstatuslong                  |severity|
|---------|-------------------------------|--------|
|C        |Created, not yet running       |15      |
|R        |Running                        |15      |
|B        |Blocked                        |15      |
|T        |Completed successfully         |10      |
|E        |Terminated with errors         |25      |
|e        |Non-fatal error                |20      |
|f        |Fatal error                    |100     |
|D        |Verify found differences       |15      |
|A        |Canceled by user               |90      |
|F        |Waiting for Client             |15      |
|S        |Waiting for Storage daemon     |15      |
|m        |Waiting for new media          |        |
|M        |Waiting for media mount        |15      |
|s        |Waiting for storage resource   |15      |
|j        |Waiting for job resource       |15      |
|c        |Waiting for client resource    |15      |
|d        |Waiting on maximum jobs        |15      |
|t        |Waiting on start time          |15      |
|p        |Waiting on higher priority jobs|15      |
|a        |SD despooling attributes       |15      |
|i        |Doing batch insert file records|15      |
|I        |Incomplete Job                 |25      |

As you can see it doesn't have the 'W' status that you use in the SQL query.
Does this jobstatus exist in my bacula version or is this table incomplete?

Marcelo
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to